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
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	41	174365	Thu, 23 July 2015 10:23 By: Lalit Kumar B
	sticky: How to use code tags and make your code easier to read By: Littlefoot on Mon, 05 September 2011	0	9417	Mon, 05 September 2011 02:20 By: Littlefoot
	Executing the run time file at SQLPLUS Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Mon, 23 April 2018	16	984	Thu, 26 April 2018 14:47 By: Bill B
	roles granted to a role Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 By: wtolentino on Thu, 26 April 2018	4	175	Thu, 26 April 2018 14:35 By: Solomon Yakobson
	Trap Constraint Errors in PL/SQL? 11g Release 11.2.0.3.0 By: whdyck on Thu, 26 April 2018	5	242	Thu, 26 April 2018 10:10 By: Michel Cadot
Database Upgrade has been moved to Server Administration by the moderator.
	Table select show blank oracle 12c Windows 2012 By: muthukrish104 on Sun, 22 April 2018	16	849	Wed, 25 April 2018 04:42 By: muthukrish104
synonym how get info on how user has access to it has been moved to Security by the moderator.
	Pagination Oracle 12 C By: satya_ora on Sun, 22 April 2018	3	490	Mon, 23 April 2018 06:42 By: Solomon Yakobson
	Handle return empty cursor in SP output parameter 11.0.2.10 By: OraFerro on Mon, 16 April 2018	9	1377	Mon, 23 April 2018 04:54 By: OraFerro
	Polish Characters are missing through the SQLPLUS Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Wed, 18 April 2018	2	972	Mon, 23 April 2018 04:44 By: saipradyumn
	Need Help In Dates sql Oraccle By: Djpats on Sat, 21 April 2018	3	400	Sat, 21 April 2018 20:20 By: Solomon Yakobson
	SQL rollup count every day By: dinavahi.saradhi@gmail.co on Thu, 19 April 2018	1	600	Thu, 19 April 2018 10:43 By: BlackSwan
	Dropping a Primary Key constraint Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professional By: buggleboy007 on Mon, 16 April 2018	15	1075	Wed, 18 April 2018 10:22 By: buggleboy007
	modification date for package SP 11.0.2.10 By: OraFerro on Mon, 16 April 2018	4	453	Tue, 17 April 2018 23:55 By: OraFerro
	Main Stored procedure to execute multiple procedures Oracle 11.2,Linux By: senmng on Mon, 16 April 2018	8	841	Tue, 17 April 2018 06:26 By: EdStevens
	SQL statement with averages By: dinavahi.saradhi@gmail.co on Mon, 16 April 2018	0	583	Mon, 16 April 2018 10:42 By: dinavahi.saradhi@gmail.co
	Please help for resolving error for PIPELINED table function call Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Mon, 16 April 2018	2	423	Mon, 16 April 2018 05:51 By: msol25
	Need Help In Plsql Procedure Plsql By: Djpats on Sat, 14 April 2018	3	784	Mon, 16 April 2018 03:23 By: cookiemonster
	divide string into multiple parts By: suji6281 on Sat, 14 April 2018	13	966	Mon, 16 April 2018 01:46 By: _jum
	Problem in adding Html code in PL/SQL procedure By: Djpats on Sat, 14 April 2018	3	777	Mon, 16 April 2018 00:34 By: Djpats
	multiple selects after with clauses By: dinavahi.saradhi@gmail.co on Thu, 12 April 2018	3	763	Fri, 13 April 2018 00:10 By: Barbara Boehmer
	group timestamp column hourly By: dinavahi.saradhi@gmail.co on Wed, 11 April 2018	3	513	Wed, 11 April 2018 13:00 By: Michel Cadot
	365 days always oracle 11g, linux By: hisham99 on Sun, 08 April 2018	14	1160	Wed, 11 April 2018 09:41 By: JPBoileau
	ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Sat, 07 April 2018	7	1169	Wed, 11 April 2018 09:14 By: saipradyumn
	Oracle 12C error tracing and debugging issue (merged 2) By: ImSandip on Mon, 09 April 2018	5	668	Mon, 09 April 2018 09:42 By: BlackSwan
	Spell out numbers to words By: Cyrille PETIT on Thu, 14 March 2002	17	9379	Fri, 06 April 2018 12:12 By: Solomon Yakobson
	Answer the query Oracle 11g Query By: Lokesh A on Thu, 05 April 2018	2	554	Fri, 06 April 2018 08:04 By: joy_division
	UNUSABLE INDEX on Partition table Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 03 April 2018	3	644	Tue, 03 April 2018 08:52 By: saipradyumn
	Resource allocation problem Oracle 12c- 12.2.0.1.0 By: suneeshvr on Mon, 02 April 2018	5	552	Mon, 02 April 2018 21:11 By: suneeshvr
	Administering queue Oracle 11.2.0.3, AIX By: arijit2004 on Fri, 30 March 2018	13	1292	Sat, 31 March 2018 04:53 By: arijit2004
	getting error "table table1 is mutating, trigger/function may no" on executing trigger ORacle 11g By: gold14388 on Thu, 29 March 2018	8	1103	Fri, 30 March 2018 10:59 By: BlackSwan
	identifier 'PACK_GEO.TRAN001' must be declared AIX, Oracle 11.2.0.3 By: arijit2004 on Fri, 30 March 2018	2	739	Fri, 30 March 2018 06:29 By: arijit2004
	How to get this table from that Database PL/SQL Developer, unknown, Win 10 By: Nanex on Thu, 29 March 2018	2	745	Thu, 29 March 2018 08:30 By: joy_division
	How to insert table alias in query Oracle 11g By: ssyr on Wed, 28 March 2018	2	500	Thu, 29 March 2018 01:53 By: Michel Cadot
	how to use variable to store comma seperated values 11G By: satya_ora on Tue, 27 March 2018	7	902	Tue, 27 March 2018 20:26 By: satya_ora
	ORA-21561: OID generation failed !! Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Redhat 6 By: fixxxer on Wed, 07 March 2018	10	1164	Tue, 27 March 2018 09:40 By: fixxxer
	oracle Trigger for E-mail notifications !! oracle 11g By: shipon_97 on Sun, 25 March 2018	10	1102	Mon, 26 March 2018 23:57 By: shipon_97
	How to log error using UTL_CALL_STACK Oracle 12c By: sss111ind on Wed, 07 March 2018	6	994	Mon, 26 March 2018 07:16 By: Bill B
	Merge 2 or more rows into 1 oracle 12c By: laredoeneko on Fri, 23 March 2018	7	1338	Sat, 24 March 2018 02:35 By: John Watson