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 :: Polls :: Message Navigator

	Topic	Replies	Views	Last message
	Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	1	9495	Fri, 24 January 2020 03:56 By: cookiemonster
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	223656	Tue, 06 November 2018 14:17 By: Solomon Yakobson
	Looping through dblinks with a cursor Oracle 12.2.0.1, RHEL 6.10 By: scoogie1973 on Thu, 23 January 2020	9	512	Fri, 24 January 2020 01:45 By: John Watson
Query For PL SQL Opportunity has been moved to Training & Certification by the moderator.
	XMLQUERY: ORA-01427: single-row subquery returns more than one row oracle 12g By: shobhakashyapgmailcom on Sun, 19 January 2020	4	1642	Wed, 22 January 2020 23:38 By: shobhakashyapgmailcom
	Query on Oracle JVM Oracle 11g By: IshwaryaMurali on Tue, 21 January 2020	4	1365	Wed, 22 January 2020 04:51 By: IshwaryaMurali
	Design Question 12c By: ora9a on Fri, 26 April 2019	37	5322	Tue, 21 January 2020 07:23 By: John Watson
	ORA-00604 & ORA-28003 - Even when not trying to change password oracle 11g By: IshwaryaMurali on Fri, 17 January 2020	7	1632	Tue, 21 January 2020 00:39 By: Michel Cadot
	Hierarchy Queries By: msinha8 on Mon, 23 December 2019	16	5254	Fri, 10 January 2020 10:22 By: msinha8
	DML operation on a table 12C By: deepakdot on Fri, 10 January 2020	2	2016	Fri, 10 January 2020 05:12 By: deepakdot
	ORA-03001 while using bulk collect By: shanthkumaar on Fri, 16 March 2007	4	6737	Thu, 09 January 2020 06:30 By: Solomon Yakobson
	Calling webservice from plsql package (merged) Oracle12c By: Shiv93 on Sun, 05 January 2020	3	2899	Mon, 06 January 2020 07:54 By: Bill B
	ORA-01031: insufficient privileges \| Database level trigger Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: vippysharma on Wed, 25 December 2019	10	4941	Mon, 06 January 2020 04:17 By: cookiemonster
	Raise exception in case clause PL/SQL function 11.2.0.1.0 By: OraFerro on Mon, 06 January 2020	4	1175	Mon, 06 January 2020 02:30 By: OraFerro
	Error performing insert Oracle Sql Developed By: Xbox2019 on Thu, 02 January 2020	1	2776	Thu, 02 January 2020 12:19 By: Michel Cadot
	WITH Clause VS INLINE View Execution Oracle 12C By: ashrubhg@gmail.com on Mon, 30 December 2019	2	3179	Wed, 01 January 2020 06:17 By: John Watson
	Pan card insert time validation (3 merged) Oracle 11g By: Sivasai506 on Thu, 26 December 2019	4	3500	Mon, 30 December 2019 06:52 By: Bill B
	Validation of PAN Number in sql query Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production By: amarjadhav on Wed, 05 June 2013	16	11756	Mon, 30 December 2019 06:44 By: Bill B
	Trying to delete bunch of users using loop but failing Oracle 12.2 By: a100 on Fri, 27 December 2019	6	2369	Fri, 27 December 2019 06:37 By: a100
	Output Dummy Record When No Record Exists Oracle 12.2 Windows 2012 By: deay on Thu, 12 December 2019	5	4299	Thu, 12 December 2019 14:00 By: deay
	Using query to Fetch the records along with user defined column value (4 merged) Oracle pl/sql By: gsaravanan on Sun, 08 December 2019	5	2752	Wed, 11 December 2019 07:19 By: Bill B
	Materialized Views Cannot set with refresh Fast "Error" Oracle 19 By: greatwhite on Mon, 09 December 2019	9	2493	Wed, 11 December 2019 05:58 By: Bill B
	How to Pass number value to a varchar field By: asadkhan_2 on Mon, 09 December 2019	4	1255	Mon, 09 December 2019 11:18 By: Solomon Yakobson
	Rows into Columns (2 merged) Oracle 10G, Windows 2012R2 By: hissam78 on Tue, 08 October 2019	11	6370	Mon, 09 December 2019 09:51 By: ramsql
	delete from table where one of the column is nested table is running long. oracle By: tdave2019 on Wed, 04 December 2019	7	2417	Thu, 05 December 2019 02:44 By: cookiemonster
	In SEND EMAIL code, how to remove Boundaries from the output Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 By: rappaj on Fri, 11 October 2019	32	9032	Wed, 04 December 2019 14:43 By: Michel Cadot
	Run Oracle SQL query multiple times with change in filter condition 12c By: vsaenath on Mon, 02 December 2019	6	2087	Tue, 03 December 2019 10:38 By: flyboy
	Want to know insert into By: kabina on Sat, 30 November 2019	3	1763	Sun, 01 December 2019 20:13 By: kabina
	Finding Date Pattern using LEAD Oracle 12c By: samiran_cts on Sun, 01 December 2019	8	1930	Sun, 01 December 2019 13:51 By: samiran_cts
	date format SQL Developer By: kabina on Wed, 27 November 2019	6	2306	Sat, 30 November 2019 08:05 By: EdStevens
	how to make table query in oracle (4 merged) 4.0.1.14 By: kabina on Wed, 27 November 2019	12	3203	Sat, 30 November 2019 02:11 By: John Watson
	ORA 01847 By: Satran on Wed, 27 November 2019	10	2357	Fri, 29 November 2019 09:08 By: cookiemonster
	bulk collect problem through dblink Orale 12c, 12.1.0.2.0 By: mape on Sat, 23 November 2019	30	5122	Fri, 29 November 2019 07:22 By: Bill B
	Break line as per required attached output. Oracle 11i By: nitesh.erp@gmail.com on Sat, 23 November 2019	16	3676	Mon, 25 November 2019 05:39 By: nitesh.erp@gmail.com
	question for reverse oracle 11g By: manoj12 on Mon, 11 November 2019	6	3778	Fri, 22 November 2019 10:39 By: Bill B
	Record Plus Prior Record - Single Row By: GIL149 on Fri, 15 November 2019	4	3261	Mon, 18 November 2019 10:00 By: JPBoileau
	Query performance condundrum. Oracle 12c Linux By: uman2631 on Fri, 15 November 2019	6	2855	Sat, 16 November 2019 11:41 By: John Watson
	Return TYpe (tablet) as output parameters. Oracle By: cristine_katia on Wed, 13 November 2019	7	4058	Fri, 15 November 2019 16:58 By: BlackSwan
	who called my procedure through a database link Oracle 10g By: Bill B on Tue, 12 November 2019	8	4466	Fri, 15 November 2019 10:22 By: Bill B
	problem to show result in join tables By: hassan08 on Sat, 09 November 2019	14	5379	Wed, 13 November 2019 11:21 By: Michel Cadot