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	35988	Mon, 05 September 2011 02:20 By: Littlefoot
	user parameters Oracle 10g By: m.abdulhaq on Thu, 06 March 2014	6	292	Sat, 08 March 2014 11:35 By: m.abdulhaq
	Want to get first day of last month 11g By: cplusplus1 on Fri, 07 March 2014	3	173	Fri, 07 March 2014 14:39 By: John Watson
	create new record from LAST record with SQL Oracle Database 11g By: oralover2006 on Thu, 06 March 2014	6	338	Fri, 07 March 2014 07:46 By: Michel Cadot
	Simple Question By: Crimzon on Fri, 07 March 2014	4	149	Fri, 07 March 2014 06:00 By: Michel Cadot
	how to call package using persistant package variable By: prasad2979 on Fri, 07 March 2014	1	90	Fri, 07 March 2014 04:58 By: Michel Cadot
log file sync issue / archive file size issue has been moved to Server Administration by the moderator.
	partition on oracle big size tables ? oracle 11g/r2/unix By: balaji123 on Fri, 07 March 2014	3	130	Fri, 07 March 2014 01:44 By: balaji123
	unit calculation Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003 By: hissam78 on Thu, 06 March 2014	3	291	Fri, 07 March 2014 01:16 By: hissam78
	Validate data Oracle 10g By: m.abdulhaq on Tue, 25 February 2014	9	555	Thu, 06 March 2014 20:44 By: m.abdulhaq
	how to remove redundant data By: evivek on Thu, 06 March 2014	1	132	Thu, 06 March 2014 14:53 By: BlackSwan
	Varchar2 Length By: OraFaq13 on Wed, 05 March 2014	3	243	Thu, 06 March 2014 11:46 By: OraFaq13
	Delete thousends of tables per script (without undo) Unix, Oracle 9.x By: forumwurm on Thu, 06 March 2014	16	904	Thu, 06 March 2014 07:19 By: Solomon Yakobson
	Need to retrieve records by getting columns from all_tab_columns By: HemaV on Thu, 06 March 2014	4	286	Thu, 06 March 2014 06:50 By: Michel Cadot
	Sending UTL_SMTP mail with jpg picture as header inside an e-mail 11.2.0.3.0 By: sivakumar121 on Mon, 07 October 2013	12	1266	Thu, 06 March 2014 04:35 By: vslabs
	ALL condition Oracle 8.1.7.0.0, Windows 2004 By: kumarvk on Tue, 04 March 2014	15	655	Thu, 06 March 2014 01:55 By: kumarvk
	Sort data output to excel (owa_util) from 2 cursor By: aryanna on Wed, 05 March 2014	1	106	Wed, 05 March 2014 20:52 By: BlackSwan
	PlSql open read cell in excel file!! Forms [32 Bit] Version 9.0.2.9.0 , oracle JInitiator: 1.3.1.9, WebUtil 1.0.2(Beta), window , IE 8 By: meteo on Wed, 05 March 2014	8	384	Wed, 05 March 2014 15:14 By: meteo
	SDO_GTYPE count and group by based on tables in all_tab_cols? By: psnepvangers on Tue, 04 March 2014	4	238	Wed, 05 March 2014 04:06 By: Michel Cadot
	Wrong result in trying to find offset change time Oracle 11.2.0.3.0 on OEL 5.7 to Oracle 11.2.0.1.0 OEL 5.7 By: Andrey_R on Tue, 04 March 2014	4	205	Wed, 05 March 2014 04:01 By: Andrey_R
	cursor_sharing force 11g r2 oracle 11g / 11gr2/unix By: balaji123 on Wed, 05 March 2014	4	113	Wed, 05 March 2014 02:22 By: Michel Cadot
	Dynamic Column Generation Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Tue, 04 March 2014	4	373	Tue, 04 March 2014 09:21 By: Solomon Yakobson
	Columns values into rows By: msinha8 on Tue, 04 March 2014	4	347	Tue, 04 March 2014 05:52 By: Michel Cadot
	Locked Stats 11 By: blackpanther on Mon, 03 March 2014	2	208	Tue, 04 March 2014 02:33 By: Roachcoach
	dbms_output.put_line oracle11g/r2/unix By: balaji123 on Tue, 04 March 2014	2	236	Tue, 04 March 2014 02:09 By: John Watson
	Rollup using with UNION By: zsiddiquis on Mon, 03 March 2014	6	409	Mon, 03 March 2014 12:01 By: Michel Cadot
	Index on column name "number"!!! By: vulcanjibe on Fri, 28 February 2014	9	617	Mon, 03 March 2014 01:29 By: Michel Cadot
	for loop 11g By: ggggg on Sun, 02 March 2014	2	287	Sun, 02 March 2014 12:52 By: Michel Cadot
	SQL - QUERY By: vippysharma on Fri, 28 February 2014	10	669	Sat, 01 March 2014 09:53 By: Michel Cadot
	Get previous quarter value By: Bluebeam on Fri, 28 February 2014	1	138	Fri, 28 February 2014 18:56 By: BlackSwan
	to find mid value pl/sql By: simplesanju on Wed, 26 February 2014	6	458	Fri, 28 February 2014 11:05 By: Michel Cadot
	SQL code to retrieve items in consective periods using TOAD for Oracle By: markw1906 on Fri, 28 February 2014	1	136	Fri, 28 February 2014 09:59 By: BlackSwan
	sql execution oracle 11g/r2 unix By: balaji123 on Fri, 28 February 2014	3	173	Fri, 28 February 2014 03:37 By: Roachcoach
	PIVOT - SQL Command not properly ended TOAD 10.6 By: kupstar on Thu, 27 February 2014	13	360	Fri, 28 February 2014 02:53 By: cookiemonster
	Open Cursor for with an Exception Clause 11g Release 2 Windows By: Duane on Thu, 27 February 2014	21	865	Thu, 27 February 2014 18:39 By: Duane
	Get Min Value Where It Is Not Null ( 1 2) By: aimy on Mon, 10 February 2014	45	2247	Thu, 27 February 2014 18:36 By: aimy
	Need help to build xml tag in oracle sql queries oracle 10g By: spatava on Thu, 27 February 2014	6	336	Thu, 27 February 2014 07:18 By: Solomon Yakobson
	DDL and DML By: deepak439 on Wed, 26 February 2014	2	189	Thu, 27 February 2014 00:46 By: Michel Cadot
	Need invalid records PL/SQL Release 11.2.0.2.0 ,Win 7 Professional By: shumail on Sun, 23 February 2014	4	383	Wed, 26 February 2014 22:26 By: ken002
	how to make it by help of procedure By: aaditya321 on Wed, 26 February 2014	3	338	Wed, 26 February 2014 01:21 By: Michel Cadot