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
  regexp_substr fix string unable to handle.
Oracle, 11g, Windows 7
By: nitesh.erp@gmail.com on Sun, 16 August 2020
16 2055 Sun, 16 August 2020 23:28
By: nitesh.erp@gmail.com
  dbms_output.put_line synchronize
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Fri, 14 August 2020
4 1619 Fri, 14 August 2020 13:15
By: Michel Cadot
  min / max date of grouped status of a values ? (merged)
oracle enterprise rdbms 18.3, linux64
By: flat on Thu, 13 August 2020
6 2091 Thu, 13 August 2020 09:33
By: flat
  update foreign key of all the referenced table of table
By: sinha73 on Mon, 10 August 2020
0 1257 Mon, 10 August 2020 23:26
By: sinha73
  Errors running Proc that compiles fine
SQL Developer Version 17.3.2.341 \ Build 341.0937
By: cfairtp on Fri, 07 August 2020
9 4761 Fri, 07 August 2020 15:44
By: Solomon Yakobson
  INSERT WHEN NOT EXIST
12c
By: deepakdot on Thu, 06 August 2020
6 3876 Fri, 07 August 2020 03:23
By: deepakdot
  - PDML disabled because single fragment or non partitioned table used
Oracle 12c
By: manoj12 on Mon, 03 August 2020
3 3135 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 2051 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 1862 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 2256 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 3622 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 3838 Mon, 27 July 2020 06:25
By: EdStevens
  Select Query suggestion
Oracle 12c
By: akssre on Thu, 23 July 2020
11 3759 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 2749 Fri, 24 July 2020 13:14
By: buggleboy007
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 1360 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 1661 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 1521 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 1334 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 1620 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 1794 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 2717 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 2449 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 1632 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 2339 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 4622 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 5473 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 3714 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 3883 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 5036 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 3909 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 6791 Fri, 03 July 2020 03:04
By: Sooqa
  Oracle query
Oracle 12c
By: srinivas.k2005 on Wed, 01 July 2020
12 6310 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 3109 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 6738 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 2629 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 6301 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 4202 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 4353 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 10421 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 2235 Thu, 25 June 2020 05:15
By: s4.ora
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: Sun Nov 29 19:27:22 CST 2020