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
oracle store procedure execution time takes too long By: ashwanth77 on Wed, 09 April 2014	13	682	Thu, 10 April 2014 12:55 By: kiranrathodkr916
date column issue oracle 11.3 By: guddu_12 on Thu, 10 April 2014	12	199	Thu, 10 April 2014 12:35 By: joy_division
Generating PDF files at oracle 10g server oracle 10g Linux By: manyal on Tue, 08 April 2014	6	225	Thu, 10 April 2014 12:33 By: Michel Cadot
How to fetch last N records from the table? By: Bikash.p on Thu, 10 April 2014	14	228	Thu, 10 April 2014 08:01 By: Michel Cadot
"Where 1=2 " . How it works internally? By: Bikash.p on Thu, 10 April 2014	3	124	Thu, 10 April 2014 05:46 By: Bikash.p
How to return 0 when Inline View is returning NULL Oracle - 11.1.0.7.0 By: akash.nathile on Thu, 06 September 2012	8	595	Thu, 10 April 2014 02:36 By: cookiemonster
CONCATENATE QUERY ORACLE, 8.1.7.0.0, WINDOWS 2007 By: kumarvk on Tue, 08 April 2014	11	532	Thu, 10 April 2014 01:02 By: Michel Cadot
How to work oracle index By: aaditya321 on Tue, 08 April 2014	6	401	Thu, 10 April 2014 00:39 By: pablolee
Oracle - generating combination of numbers By: electriceel on Mon, 25 October 2010	26	3158	Wed, 09 April 2014 13:06 By: Kosmadog
ora 01722 invalid number error By: ashwanth77 on Tue, 08 April 2014	8	408	Wed, 09 April 2014 06:48 By: Lalit Kumar B
Sort Join understanding Oracle 11g, Linux By: rekha.singhal@tcs.com on Wed, 09 April 2014	1	150	Wed, 09 April 2014 06:09 By: John Watson
Min emp details Oracle 10g By: sss111ind on Wed, 09 April 2014	1	185	Wed, 09 April 2014 05:30 By: Michel Cadot
optimize query 11 i By: usmanelahi on Wed, 09 April 2014	1	159	Wed, 09 April 2014 01:19 By: Michel Cadot
Avoiding duplicate SQL code Oracle By: na.dharma@gmail.com on Fri, 04 April 2014	6	435	Tue, 08 April 2014 09:43 By: pablolee
Date format error Oracle 10g By: sss111ind on Tue, 08 April 2014	5	256	Tue, 08 April 2014 09:04 By: sss111ind
How to get last two max values Oracle 11g By: na.dharma@gmail.com on Tue, 08 April 2014	5	275	Tue, 08 April 2014 06:12 By: Littlefoot
Oracle 10g : Connect by prior By: ashwanth77 on Tue, 08 April 2014	3	211	Tue, 08 April 2014 04:38 By: Michel Cadot
Job not being executed on time Oracle 11g r2 , Linux OEM 5.9 By: Andrey_R on Mon, 07 April 2014	10	434	Tue, 08 April 2014 03:12 By: Andrey_R
Manipulating XML Clob Oracle 11.2 By: deepugun on Mon, 07 April 2014	1	162	Mon, 07 April 2014 19:37 By: BlackSwan
How to write query for desire output? By: aaditya321 on Sat, 29 March 2014	4	377	Mon, 07 April 2014 03:58 By: Michel Cadot
mutually exclusive query Oracle, SQL By: ravikanth_b on Sun, 06 April 2014	3	232	Mon, 07 April 2014 01:41 By: ravikanth_b
Remove least paid employee who are reporting to BLAKE ? By: kiranrathodkr916 on Sun, 06 April 2014	6	285	Sun, 06 April 2014 13:27 By: EdStevens
Two row into one row conversition Oralce 11g By: na.dharma@gmail.com on Fri, 04 April 2014	9	420	Fri, 04 April 2014 10:04 By: Michel Cadot
incorrect output from my sql command 11g By: kekanap on Thu, 03 April 2014	6	393	Fri, 04 April 2014 10:01 By: Michel Cadot
finding missing parent from oracle hierarchical query 11g By: ashwanth77 on Fri, 04 April 2014	8	407	Fri, 04 April 2014 08:25 By: flyboy
ORA-12899: value too large for column Oracle 11g By: na.dharma@gmail.com on Fri, 04 April 2014	3	253	Fri, 04 April 2014 02:00 By: Michel Cadot
Date Format By: gauravgautam135 on Thu, 03 April 2014	16	715	Fri, 04 April 2014 00:26 By: gauravgautam135
sysdate problem with between() 8i By: bobghw on Thu, 03 April 2014	4	179	Thu, 03 April 2014 19:19 By: bobghw
Process cursor grp Oracle 11g By: namitanamburi on Thu, 03 April 2014	0	360	Thu, 03 April 2014 14:33 By: namitanamburi
SQL Sub Query Error ORA-00936: missing expression Oracle 11 By: rlcaputo on Thu, 03 April 2014	4	299	Thu, 03 April 2014 13:28 By: rlcaputo
Adding subpartitions in template By: Alexey.Samoilov on Thu, 03 April 2014	0	346	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	775	Thu, 03 April 2014 09:39 By: cookiemonster
Dates By: mist598 on Wed, 02 April 2014	21	707	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	155	Thu, 03 April 2014 06:15 By: saipradyumn
before insert & instead OF INSERT trigger By: mist598 on Thu, 03 April 2014	11	337	Thu, 03 April 2014 04:32 By: cookiemonster
Sharing column for partitions. By: Alexey.Samoilov on Thu, 03 April 2014	6	303	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	339	Thu, 03 April 2014 01:43 By: mazam
Problems in Oracle Hints By: aaditya321 on Wed, 02 April 2014	4	222	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	104	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	157	Wed, 02 April 2014 10:51 By: Michel Cadot