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
Creating a record from existing random records (5 merged) RDBMS 11.2.0.4 By: BeefStu on Fri, 19 June 2020	24	29322	Fri, 26 June 2020 23:44 By: Michel Cadot
ORA-00904: invalid identifier Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: s4.ora on Thu, 25 June 2020	1	7579	Thu, 25 June 2020 05:15 By: s4.ora
View and Table created from same query giving different result Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: s4.ora on Tue, 09 June 2020	4	10531	Thu, 25 June 2020 05:06 By: s4.ora
Loading a CLOB with a KEY By: Mark70 on Mon, 22 June 2020	2	7466	Mon, 22 June 2020 09:53 By: Michel Cadot
2 Rows Data into 1 Row By: Genesys on Thu, 18 June 2020	3	9932	Fri, 19 June 2020 06:00 By: Solomon Yakobson
Query not returning correct values (merged) Windows 10 Pro. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0, Forms 11g 32 bit By: buggleboy007 on Tue, 16 June 2020	11	15883	Wed, 17 June 2020 07:12 By: EdStevens
'Create table' statement is hanging SQL*Plus: Release 11.2.0.3.0 Production By: aidi-h on Mon, 15 June 2020	4	10893	Tue, 16 June 2020 12:44 By: Bill B
get closer to datetime in two tables oracle 12c By: mape on Tue, 16 June 2020	3	8122	Tue, 16 June 2020 06:00 By: mape
The ESCAPE Option By: amirmg on Wed, 10 June 2020	7	15726	Fri, 12 June 2020 02:29 By: Michel Cadot
Time Portion of Date/Time Value Being Stripped When Passed to Stored Procedure (3 merged) By: bmccollum on Tue, 09 June 2020	7	12700	Thu, 11 June 2020 03:06 By: John Watson
Multiple rows into on "TEMP" table? By: RM33 on Fri, 29 May 2020	2	8898	Wed, 10 June 2020 13:50 By: Bill B
Simple UPDATE - should be easy but just can't get it! Oracle 18c - but should apply to any version! By: dragam on Sun, 07 June 2020	6	9642	Wed, 10 June 2020 13:38 By: Bill B
Creating a not well-formed XML By: Mark70 on Wed, 10 June 2020	1	6499	Wed, 10 June 2020 05:25 By: Michel Cadot
CASE Statement on a Cursor R12 By: ajayhareesh on Mon, 08 June 2020	5	10467	Tue, 09 June 2020 07:39 By: Solomon Yakobson
Commands in SQl By: aartiyadav on Fri, 05 June 2020	4	11166	Mon, 08 June 2020 09:57 By: Michel Cadot
FORALL with associative array and INDEX BY VARCHAR xe 11g R2 By: hudo on Sat, 06 June 2020	3	9007	Sun, 07 June 2020 05:25 By: Michel Cadot
Adding [CDATA[ element in an XML By: Mark70 on Thu, 04 June 2020	2	10262	Fri, 05 June 2020 00:40 By: _jum
BLOB msg print in xml format Oracle 12c By: bkbora on Tue, 02 June 2020	4	8777	Wed, 03 June 2020 01:26 By: Michel Cadot
Split Comma seperated Value By: vharish006 on Tue, 02 June 2020	1	6646	Wed, 03 June 2020 00:03 By: Michel Cadot
Error ORA-00932 when viewing data from an OLAP cube By: Edo97 on Tue, 02 June 2020	0	6445	Tue, 02 June 2020 03:42 By: Edo97
count per group web intelligence By: jtylerrand on Sun, 31 May 2020	8	11902	Mon, 01 June 2020 11:17 By: Solomon Yakobson
ORA-06530: Reference to uninitialized composite By: sudheer45v on Sat, 30 May 2020	12	14624	Sun, 31 May 2020 05:57 By: sudheer45v
Username length limitation in Oracle By: uicmxz on Fri, 16 November 2007	6	36347	Sat, 30 May 2020 06:47 By: Bill B
Dynamic Query into Cursor Oracle 12c, Unix By: Rayam69 on Fri, 29 May 2020	1	7841	Sat, 30 May 2020 00:35 By: Michel Cadot
oracle -rearrange columns values based on value type 12.1.0.2 By: ghostman on Fri, 15 May 2020	11	11895	Thu, 28 May 2020 11:48 By: Bill B
how to display the values with prefix increment? Oracle By: ramanajak on Thu, 28 May 2020	3	6128	Thu, 28 May 2020 09:24 By: Michel Cadot
UTL_MAIL vs UTL_SMTP sending CLOB body 11.2.0.1.0 By: OraFerro on Wed, 13 May 2020	13	13340	Wed, 27 May 2020 16:53 By: Bill B
Audit Database Problem By: nisauaz on Wed, 27 May 2020	1	5822	Wed, 27 May 2020 12:24 By: Michel Cadot
materialized view issue oracle 11.2.0.3 By: irashu2001@gmail.com on Tue, 19 May 2020	7	11693	Wed, 27 May 2020 07:08 By: Bill B
Return names of bind variables Version 9.0.4.1644 01.75108 Windows (64-bit) 6.2 Build 9200 By: nbs on Sat, 23 May 2020	6	11546	Tue, 26 May 2020 02:50 By: nbs
Missing number in series of numbers Oracle 11g, windows By: Vijay55 on Wed, 18 May 2016	6	14226	Mon, 25 May 2020 07:19 By: Solomon Yakobson
key with different values By: desmond30 on Sat, 23 May 2020	3	7880	Sun, 24 May 2020 06:22 By: Solomon Yakobson
Using associated array as SP parameter 12.2 By: thegerman on Thu, 21 May 2020	6	8797	Fri, 22 May 2020 06:30 By: Solomon Yakobson
JSON Column for A Single Element with Potentially Multiple Values? Oracle 19c By: bmccollum on Thu, 21 May 2020	1	5640	Thu, 21 May 2020 17:33 By: Solomon Yakobson
The cost of FILTER operations DB 19.x By: John Watson on Thu, 21 May 2020	1	5488	Thu, 21 May 2020 05:46 By: Michel Cadot
driving_site hint DB12.x By: John Watson on Tue, 19 May 2020	20	12494	Wed, 20 May 2020 15:53 By: Lalit Kumar B
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	12	22951	Wed, 20 May 2020 08:06 By: fixxxer
Using SELECT to display various totals 12.2.0.2 By: johnw66 on Mon, 18 May 2020	4	4613	Tue, 19 May 2020 00:08 By: Michel Cadot
Transposing data in single row Oracle 12 c By: OracleDBA_beginner on Fri, 15 May 2020	11	9067	Mon, 18 May 2020 04:58 By: Lalit Kumar B
Procedure creation help By: chavva.kiru@gmail.com on Wed, 13 May 2020	8	6487	Thu, 14 May 2020 10:55 By: Michel Cadot