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
Oracle query Oracle 12c By: srinivas.k2005 on Wed, 01 July 2020	12	17838	Fri, 03 July 2020 00:09 By: Michel Cadot
Help with the minus operator RDBMS 11.2.0.4 By: BeefStu on Wed, 01 July 2020	0	6816	Wed, 01 July 2020 05:50 By: BeefStu
Extract substring equal to a 7 digits number (merged) By: annacol on Wed, 17 June 2020	12	15935	Tue, 30 June 2020 17:40 By: annacol
PLS-00801: internal error [*** ASSERT at file pdz2.c, line 4788; Illegal access (Text) Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production, TNS for Linux: Version 12.2.0.1.0 - Production By: s4.ora on Tue, 30 June 2020	0	7367	Tue, 30 June 2020 03:34 By: s4.ora
Problem with Sequence-Creation via Trigger Oracle 12.1 on an ODA (Oracle Database Appliance) By: YannVDC on Fri, 19 June 2020	10	19040	Mon, 29 June 2020 06:33 By: Bill B
ORA-00904: : invalid identifier RDBMS 11.2.0.4 By: BeefStu on Sat, 27 June 2020	4	12110	Mon, 29 June 2020 06:02 By: Bill B
Want to trigger the URL using UTL_HTTP 12.1.0.2.0 By: kavikeerthana on Sat, 27 June 2020	6	16284	Sun, 28 June 2020 07:49 By: BlackSwan
Creating a record from existing random records (5 merged) RDBMS 11.2.0.4 By: BeefStu on Fri, 19 June 2020	24	29474	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	7634	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	10588	Thu, 25 June 2020 05:06 By: s4.ora
Loading a CLOB with a KEY By: Mark70 on Mon, 22 June 2020	2	7512	Mon, 22 June 2020 09:53 By: Michel Cadot
2 Rows Data into 1 Row By: Genesys on Thu, 18 June 2020	3	9990	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	15974	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	10950	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	8168	Tue, 16 June 2020 06:00 By: mape
The ESCAPE Option By: amirmg on Wed, 10 June 2020	7	15784	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	12739	Thu, 11 June 2020 03:06 By: John Watson
Multiple rows into on "TEMP" table? By: RM33 on Fri, 29 May 2020	2	8944	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	9701	Wed, 10 June 2020 13:38 By: Bill B
Creating a not well-formed XML By: Mark70 on Wed, 10 June 2020	1	6543	Wed, 10 June 2020 05:25 By: Michel Cadot
CASE Statement on a Cursor R12 By: ajayhareesh on Mon, 08 June 2020	5	10511	Tue, 09 June 2020 07:39 By: Solomon Yakobson
Commands in SQl By: aartiyadav on Fri, 05 June 2020	4	11226	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	9060	Sun, 07 June 2020 05:25 By: Michel Cadot
Adding [CDATA[ element in an XML By: Mark70 on Thu, 04 June 2020	2	10328	Fri, 05 June 2020 00:40 By: _jum
BLOB msg print in xml format Oracle 12c By: bkbora on Tue, 02 June 2020	4	8833	Wed, 03 June 2020 01:26 By: Michel Cadot
Split Comma seperated Value By: vharish006 on Tue, 02 June 2020	1	6702	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	6487	Tue, 02 June 2020 03:42 By: Edo97
count per group web intelligence By: jtylerrand on Sun, 31 May 2020	8	11959	Mon, 01 June 2020 11:17 By: Solomon Yakobson
ORA-06530: Reference to uninitialized composite By: sudheer45v on Sat, 30 May 2020	12	14694	Sun, 31 May 2020 05:57 By: sudheer45v
Username length limitation in Oracle By: uicmxz on Fri, 16 November 2007	6	36432	Sat, 30 May 2020 06:47 By: Bill B
Dynamic Query into Cursor Oracle 12c, Unix By: Rayam69 on Fri, 29 May 2020	1	7904	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	11974	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	6168	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	13412	Wed, 27 May 2020 16:53 By: Bill B
Audit Database Problem By: nisauaz on Wed, 27 May 2020	1	5864	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	11761	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	11636	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	14307	Mon, 25 May 2020 07:19 By: Solomon Yakobson
key with different values By: desmond30 on Sat, 23 May 2020	3	7938	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	8853	Fri, 22 May 2020 06:30 By: Solomon Yakobson