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
XMLQUERY: ORA-01427: single-row subquery returns more than one row oracle 12g By: shobhakashyapgmailcom on Sun, 19 January 2020	4	3484	Wed, 22 January 2020 23:38 By: shobhakashyapgmailcom
Query on Oracle JVM Oracle 11g By: IshwaryaMurali on Tue, 21 January 2020	4	3448	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	4099	Tue, 21 January 2020 00:39 By: Michel Cadot
Hierarchy Queries By: msinha8 on Mon, 23 December 2019	16	8628	Fri, 10 January 2020 10:22 By: msinha8
DML operation on a table 12C By: deepakdot on Fri, 10 January 2020	2	3957	Fri, 10 January 2020 05:12 By: deepakdot
ORA-03001 while using bulk collect By: shanthkumaar on Fri, 16 March 2007	4	10351	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	8914	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	3103	Mon, 06 January 2020 02:30 By: OraFerro
Error performing insert Oracle Sql Developed By: Xbox2019 on Thu, 02 January 2020	1	4709	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	5546	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	6063	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	18464	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	4517	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	6408	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	5129	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	5267	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	3201	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	9764	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	5274	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	15378	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	4778	Tue, 03 December 2019 10:38 By: flyboy
Want to know insert into By: kabina on Sat, 30 November 2019	3	3697	Sun, 01 December 2019 20:13 By: kabina
Finding Date Pattern using LEAD Oracle 12c By: samiran_cts on Sun, 01 December 2019	8	4436	Sun, 01 December 2019 13:51 By: samiran_cts
date format SQL Developer By: kabina on Wed, 27 November 2019	6	4875	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	6279	Sat, 30 November 2019 02:11 By: John Watson
ORA 01847 By: Satran on Wed, 27 November 2019	10	5320	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	9275	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	6817	Mon, 25 November 2019 05:39 By: nitesh.erp@gmail.com
question for reverse oracle 11g By: manoj12 on Mon, 11 November 2019	6	6450	Fri, 22 November 2019 10:39 By: Bill B
Record Plus Prior Record - Single Row By: GIL149 on Fri, 15 November 2019	4	5775	Mon, 18 November 2019 10:00 By: JPBoileau
Query performance condundrum. Oracle 12c Linux By: uman2631 on Fri, 15 November 2019	6	5129	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	6627	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	6907	Fri, 15 November 2019 10:22 By: Bill B
problem to show result in join tables By: hassan08 on Sat, 09 November 2019	14	7574	Wed, 13 November 2019 11:21 By: Michel Cadot
Ajuda com procedure Type Pipilined Oracle By: cristine_katia on Mon, 11 November 2019	13	6964	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	8458	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	6441	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	5999	Fri, 01 November 2019 05:04 By: cookiemonster
ANALYZE TABLE STATEMENT 19C, WINDOW By: Bilal Khan on Sat, 26 October 2019	11	7528	Sat, 26 October 2019 11:34 By: Bilal Khan
Multiple Out Parameters Function in Select Statement - Oracle Oracle 11.2.0.3.0 By: myclassic on Thu, 24 October 2019	5	4907	Fri, 25 October 2019 04:47 By: myclassic