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
Looping through dblinks with a cursor Oracle 12.2.0.1, RHEL 6.10 By: scoogie1973 on Thu, 23 January 2020	9	5860	Fri, 24 January 2020 01:45 By: John Watson
XMLQUERY: ORA-01427: single-row subquery returns more than one row oracle 12g By: shobhakashyapgmailcom on Sun, 19 January 2020	4	3938	Wed, 22 January 2020 23:38 By: shobhakashyapgmailcom
Query on Oracle JVM Oracle 11g By: IshwaryaMurali on Tue, 21 January 2020	4	4115	Wed, 22 January 2020 04:51 By: IshwaryaMurali
ORA-00604 & ORA-28003 - Even when not trying to change password oracle 11g By: IshwaryaMurali on Fri, 17 January 2020	7	4963	Tue, 21 January 2020 00:39 By: Michel Cadot
Hierarchy Queries By: msinha8 on Mon, 23 December 2019	16	9714	Fri, 10 January 2020 10:22 By: msinha8
DML operation on a table 12C By: deepakdot on Fri, 10 January 2020	2	4416	Fri, 10 January 2020 05:12 By: deepakdot
ORA-03001 while using bulk collect By: shanthkumaar on Fri, 16 March 2007	4	11498	Thu, 09 January 2020 06:30 By: Solomon Yakobson
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	10583	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	3650	Mon, 06 January 2020 02:30 By: OraFerro
Error performing insert Oracle Sql Developed By: Xbox2019 on Thu, 02 January 2020	1	5194	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	6205	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	6769	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	21180	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	5174	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	6932	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	5639	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	6291	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	3896	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	10750	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	6404	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	17571	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	5499	Tue, 03 December 2019 10:38 By: flyboy
Want to know insert into By: kabina on Sat, 30 November 2019	3	4103	Sun, 01 December 2019 20:13 By: kabina
Finding Date Pattern using LEAD Oracle 12c By: samiran_cts on Sun, 01 December 2019	8	5102	Sun, 01 December 2019 13:51 By: samiran_cts
date format SQL Developer By: kabina on Wed, 27 November 2019	6	5585	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	7499	Sat, 30 November 2019 02:11 By: John Watson
ORA 01847 By: Satran on Wed, 27 November 2019	10	6541	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	11102	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	7976	Mon, 25 November 2019 05:39 By: nitesh.erp@gmail.com
question for reverse oracle 11g By: manoj12 on Mon, 11 November 2019	6	7014	Fri, 22 November 2019 10:39 By: Bill B
Record Plus Prior Record - Single Row By: GIL149 on Fri, 15 November 2019	4	6406	Mon, 18 November 2019 10:00 By: JPBoileau
Query performance condundrum. Oracle 12c Linux By: uman2631 on Fri, 15 November 2019	6	5913	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	7544	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	7451	Fri, 15 November 2019 10:22 By: Bill B
problem to show result in join tables By: hassan08 on Sat, 09 November 2019	14	8200	Wed, 13 November 2019 11:21 By: Michel Cadot
Ajuda com procedure Type Pipilined Oracle By: cristine_katia on Mon, 11 November 2019	13	8097	Tue, 12 November 2019 05:45 By: flyboy
AWR Report SQL with Bind Variables Oracle Version 12.1 By: kohila on Thu, 31 October 2019	8	9664	Wed, 06 November 2019 02:49 By: cookiemonster
ALTER TABLE STATEMENT FOR CLUSTER Oracle 19C/Window 10 By: Bilal Khan on Fri, 01 November 2019	7	7050	Sat, 02 November 2019 01:25 By: Michel Cadot
Update null value columns based upon previous non null columns 11.2 By: lott42_gmail on Thu, 31 October 2019	8	6835	Fri, 01 November 2019 05:04 By: cookiemonster
ANALYZE TABLE STATEMENT 19C, WINDOW By: Bilal Khan on Sat, 26 October 2019	11	8261	Sat, 26 October 2019 11:34 By: Bilal Khan