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
Using Case statement after "AND" Oracle SQL Developer By: rksample on Fri, 18 July 2014	5	259	Fri, 18 July 2014 06:57 By: Littlefoot
Rebuild tree with fullpath - connect by (?) 11gR2 By: ric90 on Thu, 17 July 2014	7	249	Fri, 18 July 2014 03:25 By: ric90
View is invalid Oracle 11g,Linux 2.6 By: Database admin on Thu, 17 July 2014	5	196	Thu, 17 July 2014 21:33 By: Database admin
archive & Purge of table oracle 11g / Unix By: balaji123 on Fri, 27 June 2014	7	352	Thu, 17 July 2014 12:34 By: Lalit Kumar B
SQL ISSUE oracle 11g / unix By: balaji123 on Thu, 17 July 2014	3	158	Thu, 17 July 2014 12:33 By: balaji123
get every result of a query to use after other query By: mmm286 on Thu, 17 July 2014	17	401	Thu, 17 July 2014 11:22 By: Littlefoot
Binary tree in Pl/sql By: suni786 on Mon, 14 January 2013	6	1059	Thu, 17 July 2014 06:54 By: Littlefoot
Dbms_Parallel_Execute.Run_Task gets stuck Oracle Database 11g Release 11.2.0.4.0 By: Thilinaa on Thu, 17 July 2014	0	365	Thu, 17 July 2014 06:07 By: Thilinaa
Materialized view 11g By: mvrkr44 on Wed, 16 July 2014	9	323	Wed, 16 July 2014 10:26 By: Michel Cadot
Diffrent Number and type of parameter passing 11g By: dara.naveen on Mon, 14 July 2014	3	257	Wed, 16 July 2014 02:32 By: Michel Cadot
Query to get payroll values between dates EBS R12.1.3, Oracle 11g By: afzaa2yahoocom on Tue, 15 July 2014	4	240	Wed, 16 July 2014 01:22 By: afzaa2yahoocom
Prior Week Saturday Date Oracle 10g By: gauravgautam135 on Tue, 15 July 2014	12	566	Wed, 16 July 2014 00:48 By: gauravgautam135
Query By: simiha on Tue, 15 July 2014	2	179	Tue, 15 July 2014 15:07 By: Michel Cadot
How to check words from two columns in a table and give count By: sasank54 on Tue, 15 July 2014	1	147	Tue, 15 July 2014 14:14 By: Solomon Yakobson
Declare and assign a value ot a variable Oracle 11, SQL developer By: itmasterw on Mon, 14 July 2014	11	356	Tue, 15 July 2014 11:36 By: itmasterw
oracle 11g along with XML Oracle 11g By: ashish_sun123 on Mon, 14 July 2014	7	399	Tue, 15 July 2014 10:32 By: Lalit Kumar B
Format a String to 2 decimal place By: jimjohn on Tue, 15 July 2014	11	257	Tue, 15 July 2014 08:59 By: Solomon Yakobson
Execute immediate ( 1 2) By: purnima1 on Wed, 09 July 2014	42	1122	Tue, 15 July 2014 05:02 By: purnima1
Does not exist oracle 10g By: thelearner on Mon, 14 July 2014	2	219	Tue, 15 July 2014 00:26 By: Michel Cadot
Sql Query to see the sales between dates Oracle 11g, Windows 7 By: afzaa2yahoocom on Fri, 11 July 2014	12	579	Mon, 14 July 2014 14:02 By: Lalit Kumar B
Method to take table backup Oracle 11g, Linux By: Database admin on Mon, 14 July 2014	5	238	Mon, 14 July 2014 07:57 By: Database admin
what does table.column = table.column(+) refer to By: stahorse on Mon, 14 July 2014	2	152	Mon, 14 July 2014 03:51 By: cookiemonster
Result as per Double Outer Join ? 10.2.0 By: bluetooth420 on Mon, 14 July 2014	3	151	Mon, 14 July 2014 03:01 By: bluetooth420
how to get script of table in sql plus oracle 8i By: jgjeetu on Tue, 01 July 2014	27	792	Sun, 13 July 2014 14:08 By: Lalit Kumar B
how to display any particular column first using select * query. oracle 10g sql plus By: jgjeetu on Fri, 11 July 2014	16	531	Sun, 13 July 2014 13:52 By: Lalit Kumar B
Order of WHERE columns doesn't matter? The optimizer will handle that? Oracle 11g By: rc3d on Sun, 06 July 2014	9	473	Sun, 13 July 2014 12:53 By: Kevin Meade
SYS_CONNECT_BY_PATH oracle 10g By: Mahesh P on Tue, 23 June 2009	8	3606	Sat, 12 July 2014 08:03 By: Solomon Yakobson
CBO oracle 11g / unix By: balaji123 on Thu, 03 July 2014	6	368	Sat, 12 July 2014 04:04 By: Lalit Kumar B
Parse XML to Oracle Database Oracle Database 11g Enterprise Edition Release 11.2.0.1.0, Windows 7 64 Bit By: jtnganga@gmail.com on Fri, 11 July 2014	1	188	Sat, 12 July 2014 01:25 By: Michel Cadot
Like function with Parameters Oracle 11, toad, and SQL developer By: itmasterw on Fri, 11 July 2014	8	245	Fri, 11 July 2014 13:06 By: Solomon Yakobson
to find mid value pl/sql By: simplesanju on Wed, 26 February 2014	8	706	Fri, 11 July 2014 07:14 By: jgjeetu
how to extract hh:mm from timestamp ? By: tondapi on Thu, 10 July 2014	3	183	Fri, 11 July 2014 02:28 By: Lalit Kumar B
SQL By: newastrum on Thu, 10 July 2014	3	252	Thu, 10 July 2014 08:34 By: pablolee
pass parameter into the Procedure , which are passing into the Cursor for loop in the Another Proced By: mist598 on Thu, 10 July 2014	13	332	Thu, 10 July 2014 08:04 By: Michel Cadot
pls help in query pl sql By: simplesanju on Wed, 19 February 2014	8	539	Thu, 10 July 2014 07:33 By: Roachcoach
Refcursor with returning resultset Oracle 10g By: sss111ind on Tue, 08 July 2014	15	466	Thu, 10 July 2014 06:04 By: Lalit Kumar B
query to find reserved words 10.2.0.4.0 By: grpatwari on Thu, 10 July 2014	3	239	Thu, 10 July 2014 05:15 By: Michel Cadot
help in sql query sql By: simplesanju on Fri, 03 January 2014	5	507	Thu, 10 July 2014 02:33 By: simplesanju
IN CLAUSE OUTPUT By: anniepeteroracle on Wed, 09 July 2014	6	364	Thu, 10 July 2014 01:07 By: Michel Cadot
SQL Group Query 11g By: tabj on Wed, 09 July 2014	5	336	Wed, 09 July 2014 23:24 By: tabj