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 14305 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 236189 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  Date interval Blank count
Oracle 11
By: Marinus1979 on Wed, 16 September 2020
5 1235 Fri, 18 September 2020 10:07
By: Littlefoot
  understanding table partition
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: wtolentino on Tue, 15 September 2020
9 2104 Thu, 17 September 2020 00:28
By: Michel Cadot
  Invisible double quotes
Oracle 12c Windows10
By: pstanand on Fri, 11 September 2020
8 4002 Wed, 16 September 2020 14:08
By: Michel Cadot
  How to retrieve data only those which are in decimals
oracle 12c
By: lacchhii on Tue, 15 September 2020
4 2866 Tue, 15 September 2020 06:06
By: lacchhii
  Sending email MS Word attachment containing Arabic letters
11.2.0.1.0
By: OraFerro on Sun, 06 September 2020
0 1890 Sun, 06 September 2020 04:24
By: OraFerro
  outer query returning more than one row
MS SQL
By: kumarravik on Sat, 05 September 2020
2 2365 Sat, 05 September 2020 10:24
By: Michel Cadot
  Foreign key
By: ttornado on Wed, 02 September 2020
10 2659 Fri, 04 September 2020 12:56
By: EdStevens
  to_timestamp_tz
Oracle 12c Windows10
By: pstanand on Fri, 04 September 2020
4 783 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 1106 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 2139 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 3501 Fri, 28 August 2020 06:01
By: sunilpatro08
  Future PriceCalculation based on 3 columns
Oracle 11
By: buzzi7 on Wed, 19 August 2020
2 7725 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 1287 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 3801 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 2417 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 6563 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 2354 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 1677 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 1328 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 1781 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 954 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 4251 Fri, 07 August 2020 15:44
By: Solomon Yakobson
  INSERT WHEN NOT EXIST
12c
By: deepakdot on Thu, 06 August 2020
6 3557 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 2687 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 1603 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 1553 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 1889 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 3024 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 3234 Mon, 27 July 2020 06:25
By: EdStevens
  Select Query suggestion
Oracle 12c
By: akssre on Thu, 23 July 2020
11 3021 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 2305 Fri, 24 July 2020 13:14
By: buggleboy007
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 1129 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 1335 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 1177 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 1006 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 1265 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 1187 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 2007 Wed, 15 July 2020 12:56
By: wtolentino
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: Sat Sep 19 15:00:40 CDT 2020