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	39050	Mon, 05 September 2011 02:20 By: Littlefoot
	Global Temp Table 11G By: Yuvraaj on Tue, 29 July 2014	0	6	Tue, 29 July 2014 12:46 By: Yuvraaj
MySQL Procedure not getting compiled has been moved to MySQL by the moderator.
	need the output By: mist598 on Tue, 29 July 2014	6	256	Tue, 29 July 2014 07:19 By: Lalit Kumar B
	REG_EXP csv and double quotes Oracle 11g By: wmgonzalbo on Mon, 28 July 2014	3	292	Tue, 29 July 2014 06:38 By: Michel Cadot
	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	15	900	Mon, 28 July 2014 12:59 By: Solomon Yakobson
	Generating the Range for the given dates Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Mon, 28 July 2014	5	667	Mon, 28 July 2014 12:26 By: Solomon Yakobson
	How to use distinct with 2nd column to display desired output oracle 10g By: jgjeetu on Mon, 28 July 2014	3	201	Mon, 28 July 2014 08:20 By: Lalit Kumar B
	Update a single character within string column 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production (Exadata) By: knw15pwr on Thu, 24 July 2014	10	354	Mon, 28 July 2014 07:10 By: knw15pwr
	why this code with error? By: hahaie on Sun, 27 July 2014	3	201	Mon, 28 July 2014 02:39 By: Michel Cadot
	find different or missing rows in one table Oracle, 11.2, Windows 2008R2 By: forumwurm on Sun, 27 July 2014	8	302	Mon, 28 July 2014 00:07 By: Michel Cadot
Wrapping a recursive function has been moved to JDeveloper, Java & XML by the moderator.
	SQL Oracle 11g By: ORAGENASHOK on Sun, 27 July 2014	12	301	Sun, 27 July 2014 09:39 By: Lalit Kumar B
	Calculating Index Growth 11 By: Yuvraaj on Sun, 27 July 2014	1	117	Sun, 27 July 2014 07:54 By: Michel Cadot
	Wrapper Procedure Oracle 11g By: ORAGENASHOK on Fri, 25 July 2014	6	359	Sun, 27 July 2014 07:37 By: Lalit Kumar B
	All Child tables of given table Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: saipradyumn on Sat, 26 July 2014	3	286	Sat, 26 July 2014 11:29 By: Michel Cadot
	Hierarchical query, rolling up value from child to parent Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: hendrif2 on Fri, 25 July 2014	13	516	Sat, 26 July 2014 09:19 By: Kevin Meade
	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	20	872	Fri, 25 July 2014 10:20 By: Michel Cadot
	Cocatenate (unload: function of sap hana) and each record of a coulmn which is a table name and run By: krishnapawan.44@gmail.com on Fri, 25 July 2014	22	576	Fri, 25 July 2014 07:23 By: krishnapawan.44@gmail.com
	Selecting a column not in group by clause Oracle 10g By: Member2014 on Thu, 24 July 2014	1	198	Thu, 24 July 2014 15:06 By: Michel Cadot
	Compare SUM of column to another table (column) Oracle 11g By: Laf4sens on Thu, 24 July 2014	10	295	Thu, 24 July 2014 14:43 By: Solomon Yakobson
	Getting Unique Results By: itcoracle on Tue, 22 July 2014	11	566	Thu, 24 July 2014 06:09 By: Solomon Yakobson
	Create a select statement for below scenario 10g or 11g By: sachinpawar80 on Tue, 22 July 2014	7	477	Thu, 24 July 2014 04:52 By: pablolee
	Hierarchy output 11.2.0.3.0 By: Amine on Tue, 22 July 2014	3	259	Wed, 23 July 2014 16:41 By: Amine
	How to implement the below code in the PL/SQL? By: mist598 on Wed, 23 July 2014	12	430	Wed, 23 July 2014 15:50 By: Bill B
	SQL Help 10g By: jimbojames on Tue, 22 July 2014	6	248	Wed, 23 July 2014 03:38 By: Michel Cadot
	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	219	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	360	Tue, 22 July 2014 08:23 By: Charles_Aspire_Consult
	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	369	Tue, 22 July 2014 06:59 By: Solomon Yakobson
	SQL 9i, 10g By: glmjoy on Tue, 22 July 2014	2	166	Tue, 22 July 2014 03:54 By: Lalit Kumar B
	SubQuery Problem Oracle SQL Developer 3.1.07 By: HeyMoe on Wed, 16 July 2014	13	642	Tue, 22 July 2014 02:17 By: flyboy
	use between in case on one fild By: hahaie on Mon, 21 July 2014	8	274	Tue, 22 July 2014 01:20 By: Michel Cadot
	date function By: hahaie on Sun, 20 July 2014	6	345	Tue, 22 July 2014 00:11 By: Lalit Kumar B
	Oracle RDBMS equivalent for CONCAT_WS() - create CSV output Oracle 11g By: rc3d on Mon, 21 July 2014	9	269	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	859	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	254	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	274	Sun, 20 July 2014 13:54 By: rc3d
	Table statistics 11g By: andrewscharles89 on Mon, 14 July 2014	4	398	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	1164	Fri, 18 July 2014 10:42 By: Lalit Kumar B
	Reading the xml value Oralce 10g By: sss111ind on Thu, 17 July 2014	20	532	Fri, 18 July 2014 09:42 By: Lalit Kumar B