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	34546	Mon, 05 September 2011 02:20 By: Littlefoot
	Missing employees table Oracle 11g By: Robs58 on Sun, 08 December 2013	0	1	Sun, 08 December 2013 22:28 By: Robs58
	Need procedure logic oracle 11g By: mvrkr44 on Sun, 08 December 2013	8	268	Sun, 08 December 2013 11:16 By: Michel Cadot
	Problem In Accessing The value of Outer Cursor in inner Cursor ? oracle, 11g r2, windows 7 64 bit By: jalal-rasooly on Sat, 07 December 2013	12	509	Sun, 08 December 2013 10:50 By: pablolee
	UPDATE table insert characters into a VARCHAR2 row Oracle 10g By: JimmyBob on Sat, 07 December 2013	11	445	Sun, 08 December 2013 08:52 By: Michel Cadot
	Mutating Error By: chat2raj.s on Sun, 08 December 2013	1	126	Sun, 08 December 2013 07:58 By: ThomasG
	What should be the XML format for this code. Oracle 11g By: ramya_162 on Fri, 06 December 2013	6	277	Sun, 08 December 2013 07:19 By: Solomon Yakobson
importing tables.... has been moved to Server Utilities by the moderator.
	Need package By: mvrkr44 on Sun, 08 December 2013	1	125	Sun, 08 December 2013 04:52 By: cookiemonster
	Retrieve data from string column Oracle 11g By: srinivas.k2005 on Sun, 08 December 2013	2	142	Sun, 08 December 2013 03:19 By: srinivas.k2005
Error in logging in has been moved to Backup & Recovery by the moderator.
	Fetch data with no rows in a tbale By: vishnupn on Fri, 06 December 2013	4	258	Fri, 06 December 2013 12:46 By: BlackSwan
	need sql query oracle 11g By: mvrkr44 on Fri, 06 December 2013	5	307	Fri, 06 December 2013 10:49 By: manubatham20
	anything better than substr comparison? By: lijok on Thu, 05 December 2013	5	315	Fri, 06 December 2013 08:48 By: Solomon Yakobson
	Difference in the execution plans Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: gupta27 on Thu, 05 December 2013	3	229	Fri, 06 December 2013 04:55 By: John Watson
	update oracle 10g By: thelearner on Thu, 05 December 2013	5	303	Fri, 06 December 2013 02:32 By: pablolee
	gettin ip addres and user name database oracle 11g By: otto_paiz@hotmail.com on Thu, 05 December 2013	5	306	Fri, 06 December 2013 01:53 By: Michel Cadot
	Retrieve font name available in OS using sql plus Windows 7, Oracle 10g XE By: lock_heart on Wed, 04 December 2013	16	668	Fri, 06 December 2013 01:07 By: karthik7narla
	Excel attachment by utl_smtp Oracle 11g, windows xp 32 bit By: sudeshna_bio08 on Wed, 04 December 2013	12	467	Thu, 05 December 2013 23:15 By: BlackSwan
	Need Fuzzy logic with Regular expression query oracle 11g By: mvrkr44 on Thu, 05 December 2013	2	168	Thu, 05 December 2013 12:45 By: Lalit Kumar B
	How to populate data from an Excel file to Oracle table's LOB column Oracle 9i, Linux 9 By: sonudev on Wed, 27 November 2013	4	240	Thu, 05 December 2013 12:41 By: Lalit Kumar B
	PL/SQL Package/Procedure Question 11g Release 2 Windows By: Duane on Wed, 04 December 2013	5	231	Thu, 05 December 2013 09:25 By: Duane
	What is SELECT? Oracle By: nskrishnab on Wed, 04 December 2013	12	590	Wed, 04 December 2013 11:42 By: Lalit Kumar B
	priority along with overlapping dates query 11.2.0.3 By: sasisan09 on Tue, 03 December 2013	1	196	Wed, 04 December 2013 10:10 By: sasisan09
	DBMS_CDC find only the columns that are changed along with the primary key in the table oracle 10.2.0.4 By: novice1 on Wed, 04 December 2013	6	257	Wed, 04 December 2013 07:49 By: John Watson
	Order by some columns 11g By: yuvipoy on Thu, 21 November 2013	14	717	Wed, 04 December 2013 07:13 By: EdStevens
	Query Help By: mist598 on Mon, 02 December 2013	10	616	Wed, 04 December 2013 02:56 By: cookiemonster
	How to Refresh User_tables oracle 11gR1 OEL 5.5 By: 9390512774 on Tue, 03 December 2013	3	225	Wed, 04 December 2013 00:48 By: pablolee
	Reading Particular Line in UTL_FILE oracle 11.2.0.3.0 - Windows server 2003 R2 By: muktha_22 on Mon, 02 December 2013	7	516	Wed, 04 December 2013 00:30 By: Michel Cadot
	How to use list of selected values on the body of procedure Oracle 10g, PL/SQL By: lemune on Sat, 30 November 2013	10	565	Tue, 03 December 2013 05:41 By: lemune
	split long string sql 11g By: mahnazzz on Tue, 19 February 2013	13	1341	Tue, 03 December 2013 04:18 By: mahnazzz
	query to work fast oracle 9i By: DUTTA@TARUN on Mon, 02 December 2013	8	475	Mon, 02 December 2013 17:35 By: pablolee
	How to get ddls for objects in DB and write them to a file Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: gupta27 on Mon, 25 November 2013	15	549	Mon, 02 December 2013 16:07 By: gupta27
	Comma Delimited String PL SQL By: yesh on Mon, 02 December 2013	10	420	Mon, 02 December 2013 07:35 By: dariyoosh
	ORGANIZATION_CODE must be declared By: mist598 on Mon, 02 December 2013	2	263	Mon, 02 December 2013 02:11 By: mist598
	ORA-00935: group function is nested too deeply Oracle Acadamy By: mjpowers01606 on Sat, 30 November 2013	2	201	Sun, 01 December 2013 10:20 By: mjpowers01606
	Please help with multiple update By: envision2005 on Thu, 28 November 2013	27	912	Sun, 01 December 2013 09:22 By: envision2005
	Error in reading XML message and inserting data into another DB using DB link Oracle 11g By: ramya_162 on Fri, 29 November 2013	4	309	Sat, 30 November 2013 10:58 By: ramya_162
	Multiple groupings in SQL Oracle 11.2.0.3, Linux By: sspn2010 on Wed, 20 November 2013	13	765	Sat, 30 November 2013 04:09 By: Lalit Kumar B
	Query to PIVOT oracle 11g By: srinivas.k2005 on Fri, 29 November 2013	3	273	Sat, 30 November 2013 02:43 By: pablolee