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
  Run Time Errors 933 and 512 executing Proc
SQL Developer Version 17.3.2.341
By: cfairtp on Thu, 09 July 2020
9 14434 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 12608 Wed, 08 July 2020 16:23
By: bluetooth420
  Identify the format and display the data type of a string
Oracle DB 11g
By: adfnewbie on Tue, 07 July 2020
12 14710 Tue, 07 July 2020 11:10
By: Michel Cadot
  To store table row count in the same table's comment
any version Oracle
By: Olexandr Siroklyn on Fri, 03 July 2020
4 13377 Mon, 06 July 2020 09:49
By: Olexandr Siroklyn
icon5.gif Newbie needs help with wm_concat
Oracle Database 10g Release 10.2.0.5.0 - Production; PL/SQL Release 10.2.0.5.0 - Production; "CORE 10.2.0.5.0 Production"; TNS for Linux: Version 10.2.0.5.0 - Production; NLSRTL Version 10.2
By: Operator101 on Tue, 30 June 2020
6 14640 Mon, 06 July 2020 05:51
By: Operator101
  DB link issue in cloned databases on same host
11.1.0.7.0
By: aloksk on Tue, 28 January 2020
8 17072 Fri, 03 July 2020 03:04
By: Sooqa
  Oracle query
Oracle 12c
By: srinivas.k2005 on Wed, 01 July 2020
12 19851 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 7728 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 17739 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 8506 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 21224 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 13650 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 18534 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 32606 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 8669 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 11951 Thu, 25 June 2020 05:06
By: s4.ora
  Loading a CLOB with a KEY
By: Mark70 on Mon, 22 June 2020
2 8578 Mon, 22 June 2020 09:53
By: Michel Cadot
  2 Rows Data into 1 Row
By: Genesys on Thu, 18 June 2020
3 11142 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 17822 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 12230 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 9206 Tue, 16 June 2020 06:00
By: mape
  The ESCAPE Option
By: amirmg on Wed, 10 June 2020
7 17605 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 14217 Thu, 11 June 2020 03:06
By: John Watson
  Multiple rows into on "TEMP" table?
By: RM33 on Fri, 29 May 2020
2 9941 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 10869 Wed, 10 June 2020 13:38
By: Bill B
  Creating a not well-formed XML
By: Mark70 on Wed, 10 June 2020
1 7733 Wed, 10 June 2020 05:25
By: Michel Cadot
  CASE Statement on a Cursor
R12
By: ajayhareesh on Mon, 08 June 2020
5 11821 Tue, 09 June 2020 07:39
By: Solomon Yakobson
  Commands in SQl
By: aartiyadav on Fri, 05 June 2020
4 12517 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 10237 Sun, 07 June 2020 05:25
By: Michel Cadot
  Adding [CDATA[ element in an XML
By: Mark70 on Thu, 04 June 2020
2 11598 Fri, 05 June 2020 00:40
By: _jum
  BLOB msg print in xml format
Oracle 12c
By: bkbora on Tue, 02 June 2020
4 9930 Wed, 03 June 2020 01:26
By: Michel Cadot
  Split Comma seperated Value
By: vharish006 on Tue, 02 June 2020
1 7613 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 7416 Tue, 02 June 2020 03:42
By: Edo97
  count per group
web intelligence
By: jtylerrand on Sun, 31 May 2020
8 13516 Mon, 01 June 2020 11:17
By: Solomon Yakobson
  ORA-06530: Reference to uninitialized composite
By: sudheer45v on Sat, 30 May 2020
12 16853 Sun, 31 May 2020 05:57
By: sudheer45v
  Username length limitation in Oracle
By: uicmxz on Fri, 16 November 2007
6 38216 Sat, 30 May 2020 06:47
By: Bill B
  Dynamic Query into Cursor
Oracle 12c, Unix
By: Rayam69 on Fri, 29 May 2020
1 8960 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 13357 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 7041 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 15375 Wed, 27 May 2020 16:53
By: Bill B
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: Thu May 02 00:58:23 CDT 2024