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	36870	Mon, 05 September 2011 02:20 By: Littlefoot
	Searching a string and replacing with value Oracle 10g By: sss111ind on Fri, 11 April 2014	13	875	Sat, 19 April 2014 01:55 By: sss111ind
	Transpose query help Oracle 11.2.0.4, Linux By: sspn2010 on Wed, 16 April 2014	13	959	Fri, 18 April 2014 11:59 By: sspn2010
	for loop 11g By: ggggg on Sun, 02 March 2014	12	615	Fri, 18 April 2014 07:32 By: Solomon Yakobson
	sp_log_entry By: thelearner on Thu, 17 April 2014	2	124	Thu, 17 April 2014 17:06 By: BlackSwan
	getting finacial week number oracle 11gr2 By: guddu_12 on Thu, 17 April 2014	12	489	Thu, 17 April 2014 16:21 By: dariyoosh
	Need to get max update date time last 7 days 11 By: cplusplus1 on Thu, 17 April 2014	3	253	Thu, 17 April 2014 12:52 By: Littlefoot
	Missing right paren... subquery trouble Oracle 11g By: pagoo on Wed, 16 April 2014	3	433	Wed, 16 April 2014 09:36 By: Michel Cadot
	query of status changed 11g By: usmanelahi on Tue, 15 April 2014	8	459	Wed, 16 April 2014 06:17 By: Solomon Yakobson
	Date in Words By: vipul.gupta2 on Wed, 16 April 2014	5	444	Wed, 16 April 2014 02:09 By: vipul.gupta2
	Help with PL Packages Oracle SQL By: cman348powah on Tue, 15 April 2014	2	256	Wed, 16 April 2014 01:13 By: vslabs
NUMBER datatype has been moved to Client Tools by the moderator.
	Create table in sqlplus script oracle 11g, windows os By: anncao on Tue, 15 April 2014	4	218	Tue, 15 April 2014 20:20 By: EdStevens
	how to use joins in hierarchical queries 11g By: ashwanth77 on Tue, 15 April 2014	2	107	Tue, 15 April 2014 11:31 By: Michel Cadot
	ORA-29283: invalid file operation Oracle 10g Enterprise, HPUX-B.11.11 By: bryant1003 on Tue, 15 April 2014	18	676	Tue, 15 April 2014 08:49 By: Solomon Yakobson
	How to check row count of sys_refcursor Oracle11g By: na.dharma@gmail.com on Tue, 15 April 2014	11	653	Tue, 15 April 2014 08:38 By: pointers
	how to remove columns not ending with leaf nodes in hierarchical queries 11g,toad 12.1 By: ashwanth77 on Sat, 12 April 2014	9	623	Tue, 15 April 2014 03:37 By: ashwanth77
	select query 10g By: foopaloop on Mon, 14 April 2014	1	200	Mon, 14 April 2014 22:40 By: BlackSwan
	(non)Matching nulls By: tmcallister on Mon, 14 April 2014	2	119	Mon, 14 April 2014 10:48 By: tmcallister
	how can i insert 00-jan-2014 into a date column By: ramadurga on Mon, 14 April 2014	20	672	Mon, 14 April 2014 10:28 By: Michel Cadot
	Delete all levels of employees those who are under BLAKE? By: kiranrathodkr916 on Mon, 14 April 2014	4	272	Mon, 14 April 2014 09:15 By: Solomon Yakobson
	Remove the department in dept table where dept does not have any employees? By: kiranrathodkr916 on Mon, 14 April 2014	4	196	Mon, 14 April 2014 06:26 By: cookiemonster
	Remove all entries except last one Oracle Database 11.2.0.3 Enterprise Edition By: manubatham20 on Sun, 13 April 2014	16	763	Mon, 14 April 2014 06:26 By: Michel Cadot
	can any one help me in forming the below requested query By: karthik7narla on Mon, 14 April 2014	3	301	Mon, 14 April 2014 03:23 By: Michel Cadot
	Distinct & Group By when used Analytic Function By: mist598 on Mon, 14 April 2014	2	239	Mon, 14 April 2014 02:20 By: mist598
	Historical Data Delete Query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: ArjunK on Sun, 13 April 2014	2	232	Mon, 14 April 2014 00:12 By: Littlefoot
	how to overcome mutating table error 11g,toad 12.1 By: ashwanth77 on Fri, 11 April 2014	5	388	Sun, 13 April 2014 23:22 By: flyboy
	arrange By: ghosh898 on Sun, 13 April 2014	2	135	Sun, 13 April 2014 18:38 By: Solomon Yakobson
	PL SQL prime number program explanation. PL SQL By: pkchethan on Sun, 13 April 2014	3	300	Sun, 13 April 2014 09:18 By: BlackSwan
	ORA-01830: date format picture ends before converting entire input string Oracle 11g By: na.dharma@gmail.com on Sat, 12 April 2014	2	261	Sat, 12 April 2014 13:53 By: Michel Cadot
	Multiple counts as one Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: OraFaq13 on Wed, 09 April 2014	4	345	Sat, 12 April 2014 12:27 By: OraFaq13
	Outer Join and MAX Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: OraFaq13 on Fri, 11 April 2014	10	567	Sat, 12 April 2014 05:11 By: OraFaq13
	# character is used in column Oracle 10g By: sss111ind on Sat, 12 April 2014	3	274	Sat, 12 April 2014 03:09 By: Littlefoot
	oracle pl/sql procedure oracle 10g By: karthik.m1988 on Fri, 11 April 2014	3	243	Sat, 12 April 2014 02:42 By: John Watson
	write a oracle query oracle 10gR2 RHEL By: 9390512774 on Fri, 11 April 2014	16	447	Fri, 11 April 2014 14:43 By: Solomon Yakobson
	Error in Stored procedure 11G with ODAC By: newbieDeveloper on Fri, 11 April 2014	4	139	Fri, 11 April 2014 10:43 By: Michel Cadot
	ORACLE QUERY By: juluruvenu on Fri, 11 April 2014	2	270	Fri, 11 April 2014 02:27 By: Michel Cadot
	Suggestion for Oracle AQ Dequeue Approach Oracle 10R2 By: balaji.chelladurai on Thu, 10 April 2014	4	387	Fri, 11 April 2014 02:04 By: balaji.chelladurai
	Export of Table Data to Excel through PL/SQL code Oracle Database 10g Enterprise Edition,10.2.0.4.0,IBM AIX64/RS6000 V4 - 8.1.0 By: bikash on Fri, 20 January 2012	5	1607	Fri, 11 April 2014 01:35 By: Bikash.p
	Taking a Snapshot Oracle 11g By: themitch on Thu, 10 April 2014	9	264	Fri, 11 April 2014 01:28 By: John Watson