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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
2 13392 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 233261 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  INSERT WHEN NOT EXIST
12c
By: deepakdot on Thu, 06 August 2020
5 86 Thu, 06 August 2020 13:35
By: Solomon Yakobson
  - PDML disabled because single fragment or non partitioned table used
Oracle 12c
By: manoj12 on Mon, 03 August 2020
3 1002 Thu, 06 August 2020 10:12
By: Solomon Yakobson
  Converting XML to JSON using Apex
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: wantmannu on Wed, 05 August 2020
2 215 Wed, 05 August 2020 20:44
By: wantmannu
  set default values to current epoch (2 merged)
Oracle 11.2.0.4.0 enterprise, CentOS 7.2
By: weekend79 on Wed, 05 August 2020
4 665 Wed, 05 August 2020 06:29
By: weekend79
  Need Help in Query (merged)
Oracle 12.1.2.0
By: vinodkumarn on Sat, 01 August 2020
1 1567 Sat, 01 August 2020 12:29
By: Michel Cadot
  How to get a Output as mentioned below
Product: Oracle Database 18c EE Extreme Perf ,Version:18.0.0.0.0 , Os: Windows 10
By: gsaravanan on Sun, 26 July 2020
5 2402 Wed, 29 July 2020 03:19
By: gsaravanan
  Query is taking 41 minute in Production environment
Oracle 12.1.0.1
By: manoj12 on Sat, 25 July 2020
7 2583 Mon, 27 July 2020 06:25
By: EdStevens
  Select Query suggestion
Oracle 12c
By: akssre on Thu, 23 July 2020
11 2149 Sat, 25 July 2020 10:40
By: akssre
  Unable to retrieve a record containing NULL value
Oracle forms 11g -32 bit on Windows 7 professional
By: buggleboy007 on Wed, 22 July 2020
7 1805 Fri, 24 July 2020 13:14
By: buggleboy007
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 841 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 946 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 831 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 681 Tue, 21 July 2020 09:57
By: Michel Cadot
icon5.gif ear multivalue json as rows
oracle 19
By: wjuteau on Mon, 20 July 2020
2 892 Tue, 21 July 2020 01:54
By: wjuteau
  Sorting of columns in alternative order.
11g
By: pavansivaece@gmail.com on Sat, 18 July 2020
4 649 Sat, 18 July 2020 15:18
By: Michel Cadot
  creating a materialized view throws "ORA-01031: insufficient privileges"
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 15 July 2020
5 1389 Wed, 15 July 2020 12:56
By: wtolentino
  How to Inherit data default from %TYPE attribute for a variable
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
By: Andrey_R on Wed, 15 July 2020
7 1286 Wed, 15 July 2020 10:33
By: Michel Cadot
  REGEXP_LIKE to match string in a list
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 15 July 2020
2 945 Wed, 15 July 2020 08:45
By: wtolentino
  issue in inserting pdf file in a table
oracle 12c, windows
By: form_user1 on Tue, 14 July 2020
10 822 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 3357 Fri, 10 July 2020 15:33
By: EdStevens
  Run Time Errors 933 and 512 executing Proc
SQL Developer Version 17.3.2.341
By: cfairtp on Thu, 09 July 2020
9 3902 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 2254 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 2038 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 3624 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 2180 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 4947 Fri, 03 July 2020 03:04
By: Sooqa
  Oracle query
Oracle 12c
By: srinivas.k2005 on Wed, 01 July 2020
12 4092 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 2401 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 4897 Tue, 30 June 2020 17:40
By: annacol
  Can't connect with new user created
By: Mark70 on Tue, 30 June 2020
4 1291 Tue, 30 June 2020 07:46
By: EdStevens
  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 1859 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 3911 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 2731 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 2568 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 6545 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 1210 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 2248 Thu, 25 June 2020 05:06
By: s4.ora
  Loading a CLOB with a KEY
By: Mark70 on Mon, 22 June 2020
2 1177 Mon, 22 June 2020 09:53
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: Thu Aug 06 16:21:49 CDT 2020