OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Reqular expression Oracle 11.2.0.3 By: pointers on Mon, 16 June 2014	9	418	Tue, 17 June 2014 10:44 By: Solomon Yakobson
ORA-06502: PL/SQL: numeric or value error in xmltype.getClobVal Oracle 10g By: rk_0711 on Tue, 17 June 2014	1	129	Tue, 17 June 2014 09:38 By: BlackSwan
IN Condition By: Maverick84 on Mon, 16 June 2014	8	437	Tue, 17 June 2014 04:44 By: cookiemonster
output of a refcursor which is inside a loop Oracle 11g By: ashish_2005 on Mon, 16 June 2014	14	357	Tue, 17 June 2014 04:08 By: Lalit Kumar B
Days Between Start date/today, unless Date finished. Application Express 4.1.0.00.32 By: william.wright on Mon, 16 June 2014	2	192	Tue, 17 June 2014 00:17 By: Littlefoot
Performance by which cursor is best By: aaditya321 on Mon, 16 June 2014	5	257	Mon, 16 June 2014 07:03 By: Lalit Kumar B
how to recover data in case of truncate table and drop partition By: jgjeetu on Mon, 16 June 2014	7	252	Mon, 16 June 2014 06:25 By: Michel Cadot
How to get desire output By: aaditya321 on Mon, 16 June 2014	10	311	Mon, 16 June 2014 02:49 By: Michel Cadot
function ORACLE 11G By: IRFANMBAIG on Sun, 15 June 2014	4	207	Sun, 15 June 2014 12:16 By: Littlefoot
Like with CLOB Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Sat, 14 June 2014	5	256	Sun, 15 June 2014 05:34 By: Michel Cadot
Delete statement is taking long time. Please suggest. oracle 11g By: somnathsikdar on Fri, 13 June 2014	2	207	Fri, 13 June 2014 08:58 By: Lalit Kumar B
how to remove dots in the column ( 1 2) By: mist598 on Wed, 11 June 2014	61	1461	Fri, 13 June 2014 08:04 By: John Watson
Select Query Oracle 10g,Win7 23 bit By: Xandot on Thu, 12 June 2014	12	395	Fri, 13 June 2014 05:12 By: Littlefoot
oracle package referring old schema after migration to new schema oracle 11g By: Shravan48 on Thu, 12 June 2014	5	226	Thu, 12 June 2014 09:24 By: Solomon Yakobson
Create the Sequence By: vik@s on Thu, 12 June 2014	5	204	Thu, 12 June 2014 08:31 By: Lalit Kumar B
Dealing with Intervals Oracle 11gr2 By: bluefred on Mon, 09 June 2014	3	303	Thu, 12 June 2014 03:47 By: bluefred
SQL Data preparation 11.2.0.3.0 By: grpatwari on Thu, 12 June 2014	7	265	Thu, 12 June 2014 03:46 By: Lalit Kumar B
Facing Issue with LAST_VALUE function. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit By: Manoj.Gupta.91 on Wed, 11 June 2014	28	486	Thu, 12 June 2014 02:00 By: Manoj.Gupta.91
Purpose of ODCIAggregateMerge By: user1231 on Thu, 01 May 2014	9	447	Thu, 12 June 2014 00:11 By: arielhhs
Need School Management Schema Oracle Developer, Forms 6i, Windows 8 By: azamkhan on Sun, 08 June 2014	18	672	Thu, 12 June 2014 00:11 By: Littlefoot
Query help with CUBE function Oracle 11.2.0.4, Linux By: sspn2010 on Mon, 09 June 2014	6	360	Wed, 11 June 2014 09:45 By: sspn2010
ORA-01840: input value not long enough for date format ORACLE 11g By: jayant.tripathi on Tue, 10 June 2014	5	332	Tue, 10 June 2014 08:24 By: joy_division
Correlated Sql Query Oracle 10g,Win7 23 bit By: Xandot on Mon, 09 June 2014	5	395	Tue, 10 June 2014 07:58 By: Xandot
what is a nested loop join? By: mist598 on Tue, 10 June 2014	2	214	Tue, 10 June 2014 07:40 By: Lalit Kumar B
CREATE TABLE 4.0.2 By: sarahhhh on Sun, 08 June 2014	13	604	Mon, 09 June 2014 04:55 By: flyboy
pipeline? By: hahaie on Mon, 09 June 2014	6	301	Mon, 09 June 2014 04:07 By: Lalit Kumar B
Converting SQL syntax Oracle 11g R2 By: rchenna on Fri, 06 June 2014	6	273	Fri, 06 June 2014 14:09 By: John Watson
single query by which data can fetched from table which name generated from a query oracle 10 g By: evivekj on Thu, 29 May 2014	13	1037	Fri, 06 June 2014 09:47 By: Michel Cadot
Cannot access table in PL/SQL even with direct grant 11.2.0.2 Enterprise, RHL By: d_seng on Fri, 06 June 2014	4	214	Fri, 06 June 2014 06:42 By: EdStevens
how to use substr while assigning the column & using length function By: mist598 on Fri, 06 June 2014	4	205	Fri, 06 June 2014 04:04 By: mist598
column header needs to add for each record Oracle 11g, Linux By: rahul1982 on Thu, 05 June 2014	5	328	Fri, 06 June 2014 03:46 By: rahul1982
SQL QUERY ORACLE 11G By: IRFANMBAIG on Sat, 31 May 2014	2	628	Thu, 05 June 2014 15:02 By: vemulapalli.satish83
Left outer Join nt working as desired Oracle 11g By: raj_te on Thu, 05 June 2014	6	323	Thu, 05 June 2014 13:45 By: cookiemonster
Insert with different key values to avoid contraint violation Oracle 9i By: lukeskw on Thu, 05 June 2014	8	322	Thu, 05 June 2014 13:36 By: BlackSwan
Table count with rows and no rows Oracle 10.2.0.2.0 , windows By: Jack14 on Wed, 04 June 2014	14	461	Thu, 05 June 2014 05:53 By: Jack14
Create Sql Query Oracle 11g,Win7 23 bit By: Xandot on Thu, 05 June 2014	8	351	Thu, 05 June 2014 04:19 By: Xandot
How to insert value in a partition table if the partition is not defined. By: jgjeetu on Thu, 05 June 2014	3	260	Thu, 05 June 2014 00:51 By: jgjeetu
MySQL to oracle MySQL 5.1 on centos and oracle 10g on rhel 5.4 By: tejeshrao on Tue, 27 May 2014	26	743	Wed, 04 June 2014 15:43 By: Bill B
Filter by Count of particular field By: rlsublime on Mon, 02 June 2014	18	529	Wed, 04 June 2014 12:17 By: Lalit Kumar B
how to user REGEXP for inserting data from one table to another table oracle 10g By: jgjeetu on Wed, 04 June 2014	5	315	Wed, 04 June 2014 01:45 By: Littlefoot