Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Extract substring equal to a 7 digits number (merged)
By: annacol on Wed, 17 June 2020
12 8824 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 3679 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 9020 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 5986 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 6492 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 14565 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 3521 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 5188 Thu, 25 June 2020 05:06
By: s4.ora
  Loading a CLOB with a KEY
By: Mark70 on Mon, 22 June 2020
2 3428 Mon, 22 June 2020 09:53
By: Michel Cadot
  2 Rows Data into 1 Row
By: Genesys on Thu, 18 June 2020
3 5046 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 6671 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 5194 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 3829 Tue, 16 June 2020 06:00
By: mape
  The ESCAPE Option
By: amirmg on Wed, 10 June 2020
7 7336 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 5969 Thu, 11 June 2020 03:06
By: John Watson
  Multiple rows into on "TEMP" table?
By: RM33 on Fri, 29 May 2020
2 5050 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 4765 Wed, 10 June 2020 13:38
By: Bill B
  Creating a not well-formed XML
By: Mark70 on Wed, 10 June 2020
1 2939 Wed, 10 June 2020 05:25
By: Michel Cadot
  CASE Statement on a Cursor
R12
By: ajayhareesh on Mon, 08 June 2020
5 4764 Tue, 09 June 2020 07:39
By: Solomon Yakobson
  Commands in SQl
By: aartiyadav on Fri, 05 June 2020
4 5778 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 4179 Sun, 07 June 2020 05:25
By: Michel Cadot
  Adding [CDATA[ element in an XML
By: Mark70 on Thu, 04 June 2020
2 5076 Fri, 05 June 2020 00:40
By: _jum
  BLOB msg print in xml format
Oracle 12c
By: bkbora on Tue, 02 June 2020
4 4022 Wed, 03 June 2020 01:26
By: Michel Cadot
  Split Comma seperated Value
By: vharish006 on Tue, 02 June 2020
1 3095 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 3440 Tue, 02 June 2020 03:42
By: Edo97
  count per group
web intelligence
By: jtylerrand on Sun, 31 May 2020
8 5112 Mon, 01 June 2020 11:17
By: Solomon Yakobson
  ORA-06530: Reference to uninitialized composite
By: sudheer45v on Sat, 30 May 2020
12 6041 Sun, 31 May 2020 05:57
By: sudheer45v
  Username length limitation in Oracle
By: uicmxz on Fri, 16 November 2007
6 28731 Sat, 30 May 2020 06:47
By: Bill B
  Dynamic Query into Cursor
Oracle 12c, Unix
By: Rayam69 on Fri, 29 May 2020
1 4090 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 5934 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 2594 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 5415 Wed, 27 May 2020 16:53
By: Bill B
  Audit Database Problem
By: nisauaz on Wed, 27 May 2020
1 2736 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 5251 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 5878 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 7382 Mon, 25 May 2020 07:19
By: Solomon Yakobson
  key with different values
By: desmond30 on Sat, 23 May 2020
3 4003 Sun, 24 May 2020 06:22
By: Solomon Yakobson
icon5.gif Using associated array as SP parameter
12.2
By: thegerman on Thu, 21 May 2020
6 3932 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 2399 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 2281 Thu, 21 May 2020 05:46
By: Michel Cadot
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Sat May 08 03:13:02 CDT 2021