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
Prior Week Saturday Date Oracle 10g By: gauravgautam135 on Tue, 15 July 2014	12	563	Wed, 16 July 2014 00:48 By: gauravgautam135
Query By: simiha on Tue, 15 July 2014	2	176	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	146	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	355	Tue, 15 July 2014 11:36 By: itmasterw
oracle 11g along with XML Oracle 11g By: ashish_sun123 on Mon, 14 July 2014	7	397	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	256	Tue, 15 July 2014 08:59 By: Solomon Yakobson
Execute immediate ( 1 2) By: purnima1 on Wed, 09 July 2014	42	1112	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	574	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	236	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	151	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	791	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	529	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	470	Sun, 13 July 2014 12:53 By: Kevin Meade
SYS_CONNECT_BY_PATH oracle 10g By: Mahesh P on Tue, 23 June 2009	8	3601	Sat, 12 July 2014 08:03 By: Solomon Yakobson
CBO oracle 11g / unix By: balaji123 on Thu, 03 July 2014	6	367	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	186	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	242	Fri, 11 July 2014 13:06 By: Solomon Yakobson
to find mid value pl/sql By: simplesanju on Wed, 26 February 2014	8	701	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	249	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	330	Thu, 10 July 2014 08:04 By: Michel Cadot
pls help in query pl sql By: simplesanju on Wed, 19 February 2014	8	529	Thu, 10 July 2014 07:33 By: Roachcoach
Refcursor with returning resultset Oracle 10g By: sss111ind on Tue, 08 July 2014	15	462	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	238	Thu, 10 July 2014 05:15 By: Michel Cadot
help in sql query sql By: simplesanju on Fri, 03 January 2014	5	504	Thu, 10 July 2014 02:33 By: simplesanju
IN CLAUSE OUTPUT By: anniepeteroracle on Wed, 09 July 2014	6	362	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
Subquery vs. Join performance (optimizer) Oracle 11g By: rc3d on Tue, 08 July 2014	6	314	Wed, 09 July 2014 04:14 By: rc3d
Packages 10g database, oracle 9i By: vippysharma on Wed, 09 July 2014	2	222	Wed, 09 July 2014 02:20 By: Michel Cadot
comparing collections By: purnima1 on Fri, 04 July 2014	9	501	Wed, 09 July 2014 01:28 By: purnima1
What is Analytical function? 11g By: sachinpawar80 on Mon, 07 July 2014	4	416	Wed, 09 July 2014 00:02 By: sachinpawar80
column name and procedure parameter are same in oracle Oracle 10g By: sss111ind on Tue, 08 July 2014	6	203	Tue, 08 July 2014 06:40 By: EdStevens
regarding sql query By: IRFANMBAIG on Tue, 08 July 2014	5	192	Tue, 08 July 2014 05:59 By: Michel Cadot
how to recover data from clob Oracle 11g By: zhaoquer on Wed, 02 July 2014	14	338	Tue, 08 July 2014 04:37 By: zhaoquer
ORA-29285: file write error By: Srini1234 on Tue, 24 May 2005	3	35725	Tue, 08 July 2014 01:56 By: Dina.1423
Add records in collection Pl/sql/11.2.0.2.0., Win7 By: shumail on Sun, 06 July 2014	10	356	Mon, 07 July 2014 12:25 By: shumail
Autocomplete 11g Release 2 Windows By: Duane on Mon, 07 July 2014	2	179	Mon, 07 July 2014 10:26 By: Duane
Oracle SQL - break up sequential records with the same value 11GR2 By: dgloeppky on Thu, 03 July 2014	4	233	Mon, 07 July 2014 08:49 By: Michel Cadot