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 function to extract sub string
By: talhaparvaiz@yahoo.com on Sun, 11 October 2020
2 1443 Sun, 11 October 2020 14:50
By: talhaparvaiz@yahoo.com
  RANK issue in SQL
By: aj123tx on Thu, 08 October 2020
3 1612 Sat, 10 October 2020 06:56
By: aj123tx
  Improve efficiency of script
19.2.1.247
By: Dan22 on Tue, 06 October 2020
7 1648 Fri, 09 October 2020 03:30
By: John Watson
  Duplicate delete condition
11.2
By: ritmo2k on Wed, 07 October 2020
6 1415 Thu, 08 October 2020 07:46
By: ritmo2k
  OBJECT TYPE Body creation ERROR
Oracle 19C, Window
By: Bilal Khan on Thu, 08 October 2020
3 756 Thu, 08 October 2020 05:57
By: Michel Cadot
  Join Unique Tables
By: selami on Wed, 07 October 2020
2 1027 Wed, 07 October 2020 07:36
By: John Watson
  Loop with Dates
PL/SQL (Windows/Current Oracle vers)
By: Adjanti on Mon, 05 October 2020
4 991 Tue, 06 October 2020 10:36
By: Michel Cadot
  Row Generator Using MODEL Clause, # Repeats Table-Based?
By: Art Metzer on Mon, 05 October 2020
2 898 Tue, 06 October 2020 09:39
By: Art Metzer
  Test Oracle SQL
By: misterbean on Tue, 06 October 2020
2 736 Tue, 06 October 2020 01:35
By: Michel Cadot
  extract string and compare
By: desmond30 on Mon, 05 October 2020
3 729 Mon, 05 October 2020 15:24
By: desmond30
  Pass cursor to Procedure
12.1
By: ora9a on Sun, 04 October 2020
5 1409 Mon, 05 October 2020 05:06
By: Michel Cadot
  Group pivot column
11.2.0.1.0
By: OraFerro on Sun, 04 October 2020
13 1699 Mon, 05 October 2020 01:46
By: Michel Cadot
  update column for the set of records
By: mist598 on Tue, 29 September 2020
5 1817 Tue, 29 September 2020 07:12
By: Michel Cadot
  find the next occurrence of an event based on another event
SQL Developer 19.2.1
By: ac24 on Sat, 26 September 2020
2 1852 Sat, 26 September 2020 08:52
By: Solomon Yakobson
  How to get a substring from a character on
By: Mark70 on Fri, 25 September 2020
4 1763 Fri, 25 September 2020 10:44
By: Solomon Yakobson
  Can't connect with new user created
By: Mark70 on Tue, 30 June 2020
6 3848 Fri, 25 September 2020 03:45
By: John Watson
  Date format with UTC
By: Mark70 on Thu, 18 June 2020
4 4996 Fri, 25 September 2020 03:44
By: Mark70
  How to use table functions
By: Mark70 on Wed, 03 June 2020
4 4328 Fri, 25 September 2020 03:43
By: Mark70
  How to add SOAP elements to XML
Oracle 10g
By: Mark70 on Mon, 01 June 2020
4 3542 Fri, 25 September 2020 03:43
By: Mark70
  Finding entries missing a value and listing all used values for specific data
By: magriii on Wed, 23 September 2020
6 2236 Thu, 24 September 2020 07:52
By: EdStevens
  Query help on 5 tables.
Oracle, 11g
By: krajasekhar.n@gmail.com on Tue, 22 September 2020
4 3099 Tue, 22 September 2020 22:33
By: Iffat
  Date interval Blank count
Oracle 11
By: Marinus1979 on Wed, 16 September 2020
5 8711 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 8735 Thu, 17 September 2020 00:28
By: Michel Cadot
  Invisible double quotes
Oracle 12c Windows10
By: pstanand on Fri, 11 September 2020
8 8079 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 8759 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 2259 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 2669 Sat, 05 September 2020 10:24
By: Michel Cadot
  Foreign key
By: ttornado on Wed, 02 September 2020
10 3059 Fri, 04 September 2020 12:56
By: EdStevens
  to_timestamp_tz
Oracle 12c Windows10
By: pstanand on Fri, 04 September 2020
4 1098 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 1431 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 2401 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 3895 Fri, 28 August 2020 06:01
By: sunilpatro08
  Future PriceCalculation based on 3 columns
Oracle 11
By: buzzi7 on Wed, 19 August 2020
2 8006 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 1574 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 4182 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 3014 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 6878 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 2649 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 2050 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 1617 Fri, 14 August 2020 13:15
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: Fri Nov 27 09:26:49 CST 2020