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
	Announcement: How to use [code] tags and make your code easier to read? Other people will appreciate it By: Littlefoot on Mon, 05 September 2011	0	30899	Mon, 05 September 2011 02:20 By: Littlefoot
	exp/imp failed on nasted table. 11g By: stripathee on Tue, 18 June 2013	1	37	Tue, 18 June 2013 17:11 By: BlackSwan
	remote grant 9.2.0.8 Win2003 Server By: Amine on Tue, 18 June 2013	1	27	Tue, 18 June 2013 16:46 By: cookiemonster
	date format oracle 11g By: swapnabpnn on Tue, 18 June 2013	2	28	Tue, 18 June 2013 16:44 By: cookiemonster
	Varchar2 Vs Nvarchar2 Oracle 11g By: feroze on Tue, 18 June 2013	2	42	Tue, 18 June 2013 16:31 By: Lalit Kumar B
	Passing Multiple Parameters to Cursors? Oracle 11g By: gentleman777us on Tue, 18 June 2013	9	85	Tue, 18 June 2013 16:20 By: Lalit Kumar B
	connection timeout when calling an oracle plsql function from a java program oracle 11g By: pradeep_kumar on Tue, 18 June 2013	6	61	Tue, 18 June 2013 16:12 By: Lalit Kumar B
	Incorrect query result using AVG (split from hijacked topic) By: mahila on Tue, 18 June 2013	2	86	Tue, 18 June 2013 15:36 By: Bill B
	data load oracle 10g xe, windows 7 By: knroy10 on Tue, 18 June 2013	9	97	Tue, 18 June 2013 15:29 By: Lalit Kumar B
	bind variable inside procedure 10g By: rajasekar.p.n on Tue, 18 June 2013	3	54	Tue, 18 June 2013 15:07 By: cookiemonster
	split csv to multiple records Oracle 11g By: rajivn786 on Tue, 18 June 2013	3	58	Tue, 18 June 2013 14:39 By: Michel Cadot
	SQL QUERY ERROR help Oracle 10g By: ashwini.padhy89 on Tue, 18 June 2013	4	87	Tue, 18 June 2013 14:04 By: Lalit Kumar B
	Load data from oracle to text file oracle 10.2 By: eshwar401 on Tue, 18 June 2013	12	194	Tue, 18 June 2013 07:11 By: Michel Cadot
	Replace command not working Oracle 10GR2 By: nmd_group on Tue, 18 June 2013	3	100	Tue, 18 June 2013 05:50 By: Michel Cadot
	NUMBER SERIES (merged by MC) By: MEGHAtarun on Sat, 15 June 2013	25	535	Tue, 18 June 2013 03:19 By: ThomasG
	sending arabic sms to gsm from oracle database 11g By: bahaelsharif on Sun, 16 June 2013	31	500	Tue, 18 June 2013 03:14 By: Michel Cadot
	order by By: lavkumar78 on Mon, 17 June 2013	13	285	Mon, 17 June 2013 22:18 By: BlackSwan
	overlap data need Oracle Database 11g Express Edition Release 11.2.0.2.0, Win 7 By: shumail on Mon, 17 June 2013	3	72	Mon, 17 June 2013 20:46 By: BlackSwan
	How to construct a SQL query to fetch different rows from same table in different columns? Oracle 10 By: syedabdulbaqi on Sat, 25 May 2013	21	848	Mon, 17 June 2013 14:23 By: syedabdulbaqi
	turning off pretty print Oracle 9i. No permission on server By: perikaceo on Mon, 17 June 2013	9	260	Mon, 17 June 2013 13:39 By: Michel Cadot
	enhancing performance of join oracle 10g By: enxsnx on Mon, 17 June 2013	3	283	Mon, 17 June 2013 12:41 By: Michel Cadot
	update issue oracle sql developer,oracle 11g By: siraj.accet@gmail.com on Fri, 14 June 2013	18	488	Mon, 17 June 2013 10:53 By: Lalit Kumar B
VPD Policy Function Issue. has been moved to Security by the moderator.
	spooling xml column into one single row 9 By: perikaceo on Mon, 17 June 2013	5	128	Mon, 17 June 2013 09:16 By: perikaceo
	Query help Oracle 10.2.0.5, AIX 5.3 ( 1 2) By: sminnakanti on Tue, 11 June 2013	41	797	Mon, 17 June 2013 01:46 By: Lalit Kumar B
	How to schedule the job to run evry Sunday at 12 P.M IST Oracle 11g By: ajaykumarkona on Tue, 11 June 2013	4	297	Mon, 17 June 2013 01:40 By: ajaykumarkona
	Getting all data in a single row Oracle Database 11g11.2.0.3.0 - 64bit By: atirtil on Sun, 16 June 2013	8	279	Sun, 16 June 2013 17:27 By: BlackSwan
	get End time by query between start time and duration Oracle Form6i By: medisys on Sun, 16 June 2013	6	280	Sun, 16 June 2013 14:01 By: Lalit Kumar B
	MULTIPLICATION OF NUMBER By: MEGHAtarun on Sat, 15 June 2013	4	219	Sun, 16 June 2013 06:11 By: Lalit Kumar B
	Stored Procdure with multiple table join with aggregate functions. Oracle 9i or Oracle 10g By: Sheetalraju on Sat, 15 June 2013	2	198	Sat, 15 June 2013 04:31 By: Littlefoot
	Update query for 2 lakhs rows By: satyamhcl on Wed, 12 June 2013	17	484	Sat, 15 June 2013 01:02 By: sss111ind
	Query help 11.2.0.2.0 By: guesthyd on Fri, 14 June 2013	3	209	Fri, 14 June 2013 23:59 By: guesthyd
	Creating a loop (merged 2) Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production ( 1 2) By: atirtil on Wed, 12 June 2013	50	619	Fri, 14 June 2013 18:34 By: atirtil
	Getting the next data with loop Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: atirtil on Fri, 14 June 2013	3	249	Fri, 14 June 2013 16:57 By: ThomasG
	SQL Query 10g By: vnithya on Thu, 13 June 2013	31	553	Fri, 14 June 2013 15:49 By: Lalit Kumar B
	Issue with Rownum Oracle 11g By: rpuser on Fri, 14 June 2013	1	198	Fri, 14 June 2013 11:28 By: Michel Cadot
	Flattening out a table Oracle 10G By: mxz25 on Thu, 13 June 2013	4	232	Fri, 14 June 2013 11:25 By: Michel Cadot
	Need help with inserting bulk records to the table By: diablog on Fri, 14 June 2013	5	250	Fri, 14 June 2013 10:43 By: BlackSwan
	Need all invalid records Oracle Database 11g Express Edition Release 11.2.0.2.0 -, Windows 7 By: shumail on Wed, 12 June 2013	16	524	Fri, 14 June 2013 07:15 By: Lalit Kumar B
	UTL_FILE READ TAKING TIME ORACLE 9i By: umeshchandraseth on Fri, 14 June 2013	19	262	Fri, 14 June 2013 03:01 By: cookiemonster