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	38906	Mon, 05 September 2011 02:20 By: Littlefoot
	How to implement the below code in the PL/SQL? By: mist598 on Wed, 23 July 2014	12	273	Wed, 23 July 2014 15:50 By: Bill B
	Getting Unique Results By: itcoracle on Tue, 22 July 2014	8	317	Wed, 23 July 2014 14:24 By: Solomon Yakobson
	Create a select statement for below scenario 10g or 11g By: sachinpawar80 on Tue, 22 July 2014	6	310	Wed, 23 July 2014 07:41 By: EdStevens
	Hierarchy output 11.2.0.3.0 By: Amine on Tue, 22 July 2014	2	206	Wed, 23 July 2014 07:03 By: Solomon Yakobson
Fatal NI connect error 12547 has been moved to Networking and Gateways by the moderator.
	SQL Help 10g By: jimbojames on Tue, 22 July 2014	6	215	Wed, 23 July 2014 03:38 By: Michel Cadot
PL/SQL Store Application Configuration has been moved to General by the moderator.
	Can someone tell me How to debugg the procedure in the package without using any tool toad or pl sql 10g or 11g By: sachinpawar80 on Tue, 22 July 2014	3	187	Tue, 22 July 2014 12:03 By: sachinpawar80
	Nested Aggregate Functions Group By Error Oracle 11g By: Charles_Aspire_Consult on Mon, 21 July 2014	9	342	Tue, 22 July 2014 08:23 By: Charles_Aspire_Consult
	Short-Circuit Evaluation operators in oracle Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Tue, 22 July 2014	4	188	Tue, 22 July 2014 07:30 By: Solomon Yakobson
	To_number on only number fields Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Tue, 22 July 2014	13	348	Tue, 22 July 2014 06:59 By: Solomon Yakobson
	SQL 9i, 10g By: glmjoy on Tue, 22 July 2014	2	141	Tue, 22 July 2014 03:54 By: Lalit Kumar B
	Find Words in a String 11g Release 2 Windows By: Duane on Fri, 11 July 2014	23	947	Tue, 22 July 2014 03:41 By: Barbara Boehmer
	SubQuery Problem Oracle SQL Developer 3.1.07 By: HeyMoe on Wed, 16 July 2014	13	625	Tue, 22 July 2014 02:17 By: flyboy
	use between in case on one fild By: hahaie on Mon, 21 July 2014	8	257	Tue, 22 July 2014 01:20 By: Michel Cadot
	date function By: hahaie on Sun, 20 July 2014	6	315	Tue, 22 July 2014 00:11 By: Lalit Kumar B
	How to Restrict User from Connecting to Database Through Specific hostname 11g, 11.2.0.3, AIX 7.1.0.0 By: ashishkumarmahanta80 on Mon, 21 July 2014	5	261	Mon, 21 July 2014 20:12 By: BlackSwan
	Oracle RDBMS equivalent for CONCAT_WS() - create CSV output Oracle 11g By: rc3d on Mon, 21 July 2014	9	256	Mon, 21 July 2014 14:04 By: Lalit Kumar B
	how can i used connect by prior function. oracle10g By: ajamitjain129@gmail.com on Fri, 18 July 2014	24	832	Mon, 21 July 2014 08:24 By: Michel Cadot
	Reverse Engineer any Object Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: manubatham20 on Sun, 20 July 2014	4	240	Sun, 20 July 2014 22:53 By: Lalit Kumar B
	why use BETWEEN? BETWEEN vs. <= and >= Oracle 11g By: rc3d on Sun, 20 July 2014	6	256	Sun, 20 July 2014 13:54 By: rc3d
	Table statistics 11g By: andrewscharles89 on Mon, 14 July 2014	4	385	Fri, 18 July 2014 14:15 By: Bill B
	Searching a string and replacing with value Oracle 10g By: sss111ind on Fri, 11 April 2014	15	1149	Fri, 18 July 2014 10:42 By: Lalit Kumar B
	Reading the xml value Oralce 10g By: sss111ind on Thu, 17 July 2014	20	520	Fri, 18 July 2014 09:42 By: Lalit Kumar B
	Single select query or multiple cursor output as collection By: ORAGENASHOK on Thu, 17 July 2014	4	210	Fri, 18 July 2014 07:40 By: ORAGENASHOK
	Using Case statement after "AND" Oracle SQL Developer By: rksample on Fri, 18 July 2014	5	252	Fri, 18 July 2014 06:57 By: Littlefoot
	Rebuild tree with fullpath - connect by (?) 11gR2 By: ric90 on Thu, 17 July 2014	7	242	Fri, 18 July 2014 03:25 By: ric90
	View is invalid Oracle 11g,Linux 2.6 By: Database admin on Thu, 17 July 2014	5	186	Thu, 17 July 2014 21:33 By: Database admin
	archive & Purge of table oracle 11g / Unix By: balaji123 on Fri, 27 June 2014	7	342	Thu, 17 July 2014 12:34 By: Lalit Kumar B
	SQL ISSUE oracle 11g / unix By: balaji123 on Thu, 17 July 2014	3	149	Thu, 17 July 2014 12:33 By: balaji123
	get every result of a query to use after other query By: mmm286 on Thu, 17 July 2014	17	391	Thu, 17 July 2014 11:22 By: Littlefoot
	Binary tree in Pl/sql By: suni786 on Mon, 14 January 2013	6	1048	Thu, 17 July 2014 06:54 By: Littlefoot
	Dbms_Parallel_Execute.Run_Task gets stuck Oracle Database 11g Release 11.2.0.4.0 By: Thilinaa on Thu, 17 July 2014	0	324	Thu, 17 July 2014 06:07 By: Thilinaa
	Materialized view 11g By: mvrkr44 on Wed, 16 July 2014	9	313	Wed, 16 July 2014 10:26 By: Michel Cadot
	Diffrent Number and type of parameter passing 11g By: dara.naveen on Mon, 14 July 2014	3	255	Wed, 16 July 2014 02:32 By: Michel Cadot
	Query to get payroll values between dates EBS R12.1.3, Oracle 11g By: afzaa2yahoocom on Tue, 15 July 2014	4	235	Wed, 16 July 2014 01:22 By: afzaa2yahoocom
	Prior Week Saturday Date Oracle 10g By: gauravgautam135 on Tue, 15 July 2014	12	561	Wed, 16 July 2014 00:48 By: gauravgautam135
	Query By: simiha on Tue, 15 July 2014	2	171	Tue, 15 July 2014 15:07 By: Michel Cadot
	How to check words from two columns in a table and give count By: sasank54 on Tue, 15 July 2014	1	141	Tue, 15 July 2014 14:14 By: Solomon Yakobson