oracle sql

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…

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…

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…

I have the following query which return year and the number of movie in that year: (SELECT year, COUNT(year) AS c FROM (SELECT year FROM Movie M…

I was looking at replace('ABC-DEF', '-') and regexp_replace('ABC-DEF', '-$') to help me remove all characters after a dash but I haven't been able…

Hi Guys, right now I have an array that stores a fruitname, price, quantity. My code looks like this: <?php session_start(); echo…

Hi All, I have more than 100GB size of table in my database I want to rename the table name. Is it a good idea?

Hi guys! I had sqlite database which contained nearly 100k entries. SQL features of sqlite turned out to be insufficient for my needs, so i decided…

I have to tables in my database : table1 column1|column2|column5|column13 harry marry stan kyle table2 column1|column2|column12|column7 kenny eric…

I have an oracle table with a varchar(100) column, and I need separate rows based on the strings combinations inside that column. The string…

I have a SQL that uses REGEXP_LIKE function in the where clause, now i need the equivalent of that function which will run in Oracle 8i. The regex…

I am trying to make a method for a class that will automatically insert a record into a table. The problem is that I need to make the code work for…

hi , i need to show a chatlog by sessions and the session may be splitted by the duration of 30 minutes gap between each message. here the sample…

Hi, If i has a group of people identifiers (12,34,54,65) and a database with Keys (Gender, Age, Salary for example), such as: Details table {Person…

Hi, I have installed Oracle SQL Developer 3 and I tried to connect to mysql database. I used tutorials, which told me to use…

Possible Duplicate: How do I limit the number of rows returned by an oracle query? I have this query select * from pr_device_reading order by…

Hi All, Actually I have some oracle query which is about oracle database default tables. That is working in the oracle. Now I want to execute those…

hello We want an output table to obtain the rows to simulate DB: SampleTable1 Name Product Jan Book Smith Glass .... ..... select * from…

Say I want to allow in a table column only strings that begin with a numeral and should not contain '$' in it. How would a check constraint on this…

Extending on How does hibernate use an empty string for an equality restriction? I am having a problem about how to check for an empty string…