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	36976	Mon, 05 September 2011 02:20 By: Littlefoot
	Find out last four digits Oracle By: Shyam.reddy141 on Thu, 24 April 2014	3	41	Thu, 24 April 2014 13:13 By: Solomon Yakobson
	Get information from LDAP By: srivardhan on Wed, 08 July 2009	24	6949	Thu, 24 April 2014 11:10 By: EdStevens
	Case Statement - Best Practice - Close with Else Null? SQL By: smedvid on Thu, 24 April 2014	2	115	Thu, 24 April 2014 10:12 By: smedvid
	ORA-28002 error while connecting DB LINK By: Bikash.p on Wed, 23 April 2014	9	281	Thu, 24 April 2014 09:47 By: EdStevens
	New to sql and need some help please (merged) SQL Plus By: om357 on Wed, 23 April 2014	15	633	Thu, 24 April 2014 00:58 By: Michel Cadot
Need to Understand Explain plan has been moved to Performance Tuning by the moderator.
	Unable to display contents of CHARARR; SQL Developer By: plsqlnewbie on Tue, 22 April 2014	12	302	Wed, 23 April 2014 09:06 By: Solomon Yakobson
	oracle pl/sql procedure oracle 10g By: karthik.m1988 on Fri, 11 April 2014	24	868	Wed, 23 April 2014 07:44 By: Michel Cadot
	Job not being executed on time Oracle 11g r2 , Linux OEM 5.9 By: Andrey_R on Mon, 07 April 2014	12	573	Wed, 23 April 2014 05:56 By: Michel Cadot
How to save time format to 24 hour while importing data from xls file has been moved to Client Tools by the moderator.
	join field depending on condition DB Visualizer SQL ORACLE By: epr55 on Tue, 22 April 2014	8	241	Tue, 22 April 2014 13:12 By: Michel Cadot
	Data Type Number Oracle 11g By: teck_lee80@yahoo.com on Mon, 21 April 2014	5	226	Tue, 22 April 2014 01:36 By: Michel Cadot
performance Tuning has been moved to Performance Tuning by the moderator.
	How to join two table with no duplicate By: ocpsujon on Sun, 20 April 2014	17	838	Sun, 20 April 2014 22:34 By: ocpsujon
	case insensitive search UPPER/LOWER() vs. NLSSORT Oracle 10g By: rc3d on Sun, 20 April 2014	2	255	Sun, 20 April 2014 09:19 By: Lalit Kumar B
	Searching a string and replacing with value Oracle 10g By: sss111ind on Fri, 11 April 2014	13	922	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	987	Fri, 18 April 2014 11:59 By: sspn2010
	for loop 11g By: ggggg on Sun, 02 March 2014	12	647	Fri, 18 April 2014 07:32 By: Solomon Yakobson
	sp_log_entry By: thelearner on Thu, 17 April 2014	2	138	Thu, 17 April 2014 17:06 By: BlackSwan
	getting finacial week number oracle 11gr2 By: guddu_12 on Thu, 17 April 2014	12	519	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	270	Thu, 17 April 2014 12:52 By: Littlefoot
	Missing right paren... subquery trouble Oracle 11g By: pagoo on Wed, 16 April 2014	3	447	Wed, 16 April 2014 09:36 By: Michel Cadot
	query of status changed 11g By: usmanelahi on Tue, 15 April 2014	8	481	Wed, 16 April 2014 06:17 By: Solomon Yakobson
	Date in Words By: vipul.gupta2 on Wed, 16 April 2014	5	471	Wed, 16 April 2014 02:09 By: vipul.gupta2
	Help with PL Packages Oracle SQL By: cman348powah on Tue, 15 April 2014	2	285	Wed, 16 April 2014 01:13 By: vslabs
	Create table in sqlplus script oracle 11g, windows os By: anncao on Tue, 15 April 2014	4	245	Tue, 15 April 2014 20:20 By: EdStevens
	how to use joins in hierarchical queries 11g By: ashwanth77 on Tue, 15 April 2014	2	126	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	695	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	665	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	626	Tue, 15 April 2014 03:37 By: ashwanth77
	select query 10g By: foopaloop on Mon, 14 April 2014	1	211	Mon, 14 April 2014 22:40 By: BlackSwan
	(non)Matching nulls By: tmcallister on Mon, 14 April 2014	2	128	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	688	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	281	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	204	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	773	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	308	Mon, 14 April 2014 03:23 By: Michel Cadot
	Distinct & Group By when used Analytic Function By: mist598 on Mon, 14 April 2014	2	246	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	238	Mon, 14 April 2014 00:12 By: Littlefoot