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
  xml to json conversion
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: wantmannu on Thu, 03 September 2020
1 5627 Fri, 04 September 2020 05:11
By: Solomon Yakobson
  Oracle: create a partition by reference (partition by reference(fk)) on non referenced table
By: yarfaoui on Tue, 01 September 2020
1 8955 Tue, 01 September 2020 04:57
By: John Watson
  Oracle Procedure with table name as parameter
Oracle 11g
By: sunilpatro08 on Wed, 26 August 2020
11 16659 Fri, 28 August 2020 06:01
By: sunilpatro08
  Future PriceCalculation based on 3 columns
Oracle 11
By: buzzi7 on Wed, 19 August 2020
2 11840 Thu, 27 August 2020 00:18
By: Michel Cadot
  row_number with duplicity
12.1.0.2.0
By: mape on Wed, 26 August 2020
3 5458 Wed, 26 August 2020 07:58
By: mape
  Find out how long is the field or column
By: james94539 on Thu, 06 August 2020
2 8471 Mon, 24 August 2020 08:51
By: Bill B
  ORA-29279: SMTP permanent error (split from hijacked topic)
By: samsam on Sat, 22 August 2020
2 11716 Sat, 22 August 2020 13:28
By: EdStevens
  Select and load CLOB column data into another table
Oracle 11g
By: pmreddy.mahi@gmail.com on Wed, 19 August 2020
3 11147 Wed, 19 August 2020 08:10
By: Michel Cadot
icon8.gif SQL CASE or IF Else Condition
DB 12C
By: wasimK on Mon, 17 August 2020
2 6860 Mon, 17 August 2020 13:38
By: Solomon Yakobson
  regexp_substr fix string unable to handle.
Oracle, 11g, Windows 7
By: nitesh.erp@gmail.com on Sun, 16 August 2020
16 9051 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 6602 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 6781 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 5244 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 12447 Fri, 07 August 2020 15:44
By: Solomon Yakobson
  INSERT WHEN NOT EXIST
12c
By: deepakdot on Thu, 06 August 2020
6 8933 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 10006 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 10739 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 7044 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 7165 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 12710 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 12589 Mon, 27 July 2020 06:25
By: EdStevens
  Select Query suggestion
Oracle 12c
By: akssre on Thu, 23 July 2020
11 14845 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 9680 Fri, 24 July 2020 13:14
By: buggleboy007
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 5716 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 7165 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 6867 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 6604 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 6925 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 10505 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 13912 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 11234 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 7334 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 13060 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 14092 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 17406 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 15259 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 18351 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 15744 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 17617 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 20071 Fri, 03 July 2020 03:04
By: Sooqa
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: Wed Jul 16 06:13:20 CDT 2025