oracle

I'm a OSGI newbie looking for some help. I've been asked to create a simple REST bundle which invokes one of our databases to obtain information. I…

I have a bunch of products with a bunch of different possible attributes for each product. E.g. Product A has a name, size, color, shape. Product B…

I'm going to start a simple SaaS application and am considering which DB to go with(MSSQL, MySql, Oracle). Can someone who experience it(actual…

my current system is retrieve data from sql server and insert into oracle server every 6 hours. i use own program to do this process. i want to…

I am trying to point a Tomcat webapp from one Oracle database to another. To do so, I navigated to the webapps/[my web app]/WEB-INF/classes folder,…

I want to extract text from a column using regular expressions in Oracle 11g. I have 2 queries that do the job but I'm looking for a (cleaner/nicer)…

When using stored procedure is it faster to return a cursor back? or is it faster to use the out data parameter of the data type. or it really won't…

I am considering designing a relational DB schema for a DB that never actually deletes anything (sets a deleted flag or something). 1) What metadata…

Using BIRT 2.3.1, when I run a report, the BIRT web viewer simply hangs. It displays the toolbar, but does not display the "loading..." progress…

My question is Write an SQL query that will determine which is the least expensive venue that will accommodate 120 people. The Code i wrote select…

Is it possible to do SQL's CLR assembly in other DBMS? or what would be the CLR analog in DBMS Oracle, MySQL, PostgreSQL ...

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

Here's the scenario: I have a MySQL DB, and an Oracle DB, and what I want to do is copy data back and forth, on a scheduled basis. What is the best…

I have the following MySQL query specified within a JSP. I want to figure out an equivelant query that I can run properly against Oracle Database as…

I don't have much experience on Java based enterprise desktop applications. I need to create an enterprise application with the database. Can you…

Are there queries in other databases equivalent to Oracle's very useful ANALYZE TABLE.. ? I am looking for alternatives for the following Database…

I am using Talend studio, testing it for a simple migration from an Oracle database to a postGres database. The two connections are ok, but I got…

I have a little silly question. I have installed a PostgreSQL DB Server, but when I run query, there is a problem with column identifier without…

I have the following query in MySQL and want to convert it to Oracle. I tried row_number() function and subqueries in Oracle but could not make it…

Well after some playing and failing it turns out i have header clashes with Eclipse and MINGW compiler while using the DTL library (…