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
SQL Sub Query Error ORA-00936: missing expression Oracle 11 By: rlcaputo on Thu, 03 April 2014	4	364	Thu, 03 April 2014 13:28 By: rlcaputo
Adding subpartitions in template By: Alexey.Samoilov on Thu, 03 April 2014	0	391	Thu, 03 April 2014 13:08 By: Alexey.Samoilov
Select distinct record based on NULL date or most recent date 2005 SQL SSIS By: jbaisch on Wed, 02 April 2014	19	890	Thu, 03 April 2014 09:39 By: cookiemonster
Dates By: mist598 on Wed, 02 April 2014	21	788	Thu, 03 April 2014 06:45 By: EdStevens
Need to get only characters from the given string By: saipradyumn on Thu, 03 April 2014	2	211	Thu, 03 April 2014 06:15 By: saipradyumn
before insert & instead OF INSERT trigger By: mist598 on Thu, 03 April 2014	11	478	Thu, 03 April 2014 04:32 By: cookiemonster
Sharing column for partitions. By: Alexey.Samoilov on Thu, 03 April 2014	6	363	Thu, 03 April 2014 03:43 By: Alexey.Samoilov
Unable to get running total conditionally Oracle Database 10g Rel.2 By: mazam on Wed, 02 April 2014	6	451	Thu, 03 April 2014 01:43 By: mazam
Problems in Oracle Hints By: aaditya321 on Wed, 02 April 2014	4	273	Thu, 03 April 2014 00:55 By: aaditya321
passing values from Refcursor into Object type Oracle 9i By: anoopmanagoli on Wed, 02 April 2014	1	150	Wed, 02 April 2014 23:29 By: BlackSwan
Group Values by date/Pivot in PLSQL query plsql By: manishc1989 on Wed, 02 April 2014	1	220	Wed, 02 April 2014 10:51 By: Michel Cadot
How to get when_no_data found exception messages using cursor for loop By: mist598 on Tue, 01 April 2014	10	567	Wed, 02 April 2014 04:57 By: Michel Cadot
Get value between two fields Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003 By: hissam78 on Tue, 01 April 2014	5	333	Wed, 02 April 2014 02:44 By: hissam78
ROW_NUMBER() OVER( ORDER BY 2, 1 ) Oracle 11g Release 2 By: Manoj.Gupta.91 on Wed, 02 April 2014	3	321	Wed, 02 April 2014 02:31 By: Michel Cadot
GRANTS to user to insert data in table with procedure By: Alexey.Samoilov on Wed, 02 April 2014	2	219	Wed, 02 April 2014 02:27 By: Alexey.Samoilov
Change by query widt Change by query without group operation By: Alexey.Samoilov on Tue, 01 April 2014	2	208	Wed, 02 April 2014 01:45 By: Alexey.Samoilov
Grant Create Table On few tables Oracle 11g Release 2 By: azeem87 on Tue, 01 April 2014	4	242	Tue, 01 April 2014 18:29 By: EdStevens
Query that will compare two tables row by row and returns distinct rows from both tables By: Alexey.Samoilov on Tue, 01 April 2014	4	308	Tue, 01 April 2014 15:00 By: Solomon Yakobson
raise error propagation oracle 11g2, windows os By: anncao on Tue, 01 April 2014	1	134	Tue, 01 April 2014 12:07 By: BlackSwan
VIEW with Global Variables - help needed By: oralover2006 on Tue, 01 April 2014	2	257	Tue, 01 April 2014 07:04 By: oralover2006
creating oracle tablespace and quotasize dynamically ORACLE 11g By: santhosha4db on Tue, 01 April 2014	17	774	Tue, 01 April 2014 04:59 By: Michel Cadot
Longest word PL SQL By: Ben892 on Mon, 31 March 2014	3	327	Tue, 01 April 2014 01:16 By: John Watson
30 minute Time Interval By: ertweety11 on Wed, 26 March 2014	17	959	Mon, 31 March 2014 05:37 By: oralover2006
Case statement with null in where clause oracle 10g, Toad, xp By: Crimzon on Sun, 30 March 2014	2	385	Sun, 30 March 2014 12:07 By: Solomon Yakobson
How to store GMT timestamp in Database from SQL Developer import excelsheet Oracle 11g R2 By: cpadesur on Sun, 30 March 2014	3	405	Sun, 30 March 2014 07:45 By: Solomon Yakobson
ORA-00904: "CNT": invalid identifier error Oralce 11g By: na.dharma@gmail.com on Sat, 29 March 2014	2	292	Sat, 29 March 2014 07:28 By: na.dharma@gmail.com
How to handle error in 5th counting on cursor By: aaditya321 on Sat, 29 March 2014	4	345	Sat, 29 March 2014 04:00 By: dariyoosh
Union??? or Merge of tables By: ertweety11 on Fri, 28 March 2014	3	269	Fri, 28 March 2014 15:43 By: BlackSwan
how to use substr if the error ORA-01403: no data found. By: mist598 on Fri, 28 March 2014	3	266	Fri, 28 March 2014 09:07 By: cookiemonster
Nested Select for summary 11g By: andysam23586 on Fri, 28 March 2014	3	270	Fri, 28 March 2014 08:54 By: BlackSwan
Sorting Issue ORACLE 9i By: Sandeep321 on Thu, 27 March 2014	18	563	Fri, 28 March 2014 05:37 By: Solomon Yakobson
Unable to update a table at remote db in named pl/sql procedure By: sonalpatel_cse on Thu, 27 March 2014	2	170	Thu, 27 March 2014 13:27 By: Solomon Yakobson
use of EXTEND in Collection in NESTED TABLES By: mist598 on Thu, 27 March 2014	7	460	Thu, 27 March 2014 03:56 By: mist598
One more condition in this script Oracle,8.1.7.0.0,Windows 2003 Server By: kumarvk on Wed, 26 March 2014	8	437	Thu, 27 March 2014 03:35 By: cookiemonster
where can i call the procedure in the procedure in the package By: mist598 on Wed, 26 March 2014	11	487	Wed, 26 March 2014 08:18 By: cookiemonster
Please help - comma separated values Oracle Database 11g Release 11.2.0.3.0 By: oralover2006 on Wed, 26 March 2014	6	354	Wed, 26 March 2014 05:50 By: oralover2006
Oracle transpose rows into columns Oracle 11g By: developer12 on Mon, 24 March 2014	12	781	Wed, 26 March 2014 03:13 By: Michel Cadot
if in field value "Delete", then don't join other table Oracle 10g By: rc3d on Mon, 24 March 2014	5	406	Tue, 25 March 2014 05:56 By: cookiemonster
Insufficient privileges in DBMS_SESSION.SET_CONTEXT Oracle 11.2.0.1.0 on OEL 5.7 By: Andrey_R on Sun, 23 March 2014	4	565	Tue, 25 March 2014 04:57 By: Andrey_R
Dynamic column selection 11g By: okela_vp on Tue, 10 December 2013	6	577	Tue, 25 March 2014 00:14 By: Barbara Boehmer