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
  to_timestamp_tz
Oracle 12c Windows10
By: pstanand on Fri, 04 September 2020
4 1656 Fri, 04 September 2020 12:54
By: EdStevens
  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 1910 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 2860 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 4482 Fri, 28 August 2020 06:01
By: sunilpatro08
  Future PriceCalculation based on 3 columns
Oracle 11
By: buzzi7 on Wed, 19 August 2020
2 8561 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 2032 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 4782 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 4346 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 7440 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 3155 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 2589 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 2120 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 2590 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 1825 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 5649 Fri, 07 August 2020 15:44
By: Solomon Yakobson
  INSERT WHEN NOT EXIST
12c
By: deepakdot on Thu, 06 August 2020
6 4345 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 3948 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 3218 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 2347 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 2951 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 4806 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 5076 Mon, 27 July 2020 06:25
By: EdStevens
  Select Query suggestion
Oracle 12c
By: akssre on Thu, 23 July 2020
11 5419 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 3721 Fri, 24 July 2020 13:14
By: buggleboy007
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 1943 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 2407 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 2369 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 2165 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 2435 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 3110 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 4240 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 3706 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 2412 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 3930 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 6153 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 7340 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 5470 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 6024 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 6752 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 6015 Mon, 06 July 2020 05:51
By: Operator101
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: Mon May 17 22:53:43 CDT 2021