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
  Trigger on Table (4 merged)
Oracle 19C database
By: ettentrala on Fri, 19 February 2021
5 2916 Sat, 20 February 2021 01:28
By: John Watson
  postgres Range Type equivalent in oracle.
Oracle19c
By: Shrin on Thu, 18 February 2021
4 2747 Thu, 18 February 2021 11:20
By: Michel Cadot
icon9.gif How to show records on zero on hand (Job pick list)
EBiz, 11.5.10.2
By: jasmine.hue on Mon, 22 September 2008
11 6482 Wed, 17 February 2021 12:16
By: pablolee
  date validation
OS
By: suji6281 on Fri, 01 March 2019
15 7197 Sun, 14 February 2021 08:53
By: EdStevens
  Max value row and lookup value
By: suji6281 on Wed, 10 February 2021
4 2441 Wed, 10 February 2021 17:24
By: suji6281
  Parse Json using Oracle SQL
Oracle DB version 12.1.02
By: Shre on Fri, 05 February 2021
5 4264 Mon, 08 February 2021 03:22
By: Shre
  Regexp_like
Oracle 12c, Win 10
By: rajivn786 on Fri, 05 February 2021
8 3871 Sat, 06 February 2021 01:43
By: Michel Cadot
  old hash value is used to identify same sql and Plan hash value is to identify sql plans?
19.0.0 windows 2016
By: juniordbanewbie on Fri, 05 February 2021
0 2885 Fri, 05 February 2021 04:30
By: juniordbanewbie
  Alternative approach for a query run programmatically.
12
By: ritmo2k on Mon, 01 February 2021
14 6313 Thu, 04 February 2021 11:38
By: Michel Cadot
  ROW_NUMBER() not working properly?
By: chachamenci on Thu, 28 January 2021
4 6761 Mon, 01 February 2021 10:44
By: chachamenci
  Transfer the temporary file to the client machine after all files have been processed.
forms 10g
By: cristine_katia on Mon, 01 February 2021
0 4063 Mon, 01 February 2021 09:17
By: cristine_katia
  How to Repeat Row by Specific Value in Data Field
Oracle EBS R12
By: ags.island on Sun, 31 January 2021
4 4654 Mon, 01 February 2021 00:50
By: ags.island
  logic sql or plsql (merged)
By: yashi7777 on Sat, 23 January 2021
28 7297 Mon, 25 January 2021 23:59
By: Michel Cadot
  print "+" when using to_char
oracle 12c r1
By: robh0502 on Sun, 24 January 2021
3 2812 Mon, 25 January 2021 05:19
By: Bill B
  Regex Help
By: ssmith001 on Thu, 07 January 2021
3 12746 Mon, 25 January 2021 05:16
By: Bill B
  Weird PL/SQL behavior with SQL statement containing a function in WITH clause
12.1 to 19.8
By: Michel Cadot on Fri, 15 January 2021
0 5426 Fri, 15 January 2021 13:39
By: Michel Cadot
  After "Drop Materialized View" it's data continuing be shown
Oracle Database 12c EE 12.2.0.1.0 on Windows 64bit
By: jrgOra on Tue, 12 January 2021
4 5049 Wed, 13 January 2021 17:21
By: jrgOra
  Substring Query in Oracle SQL
Oracle 11g
By: abhayman on Fri, 08 January 2021
8 11350 Fri, 08 January 2021 06:35
By: Solomon Yakobson
  DBMS_HS_PASSTHROUGH - Database Link as Input Parameter
By: aimy on Wed, 06 January 2021
8 9573 Fri, 08 January 2021 00:35
By: Michel Cadot
  opening and closing balance
oracle 19c
By: learner123 on Thu, 07 January 2021
3 7893 Thu, 07 January 2021 06:36
By: learner123
  SQL query.
Oracle 11g.
By: akarra21 on Mon, 28 December 2020
10 9174 Wed, 06 January 2021 00:02
By: Michel Cadot
  oracle pl/sql
11g
By: thirunakar ramesh on Mon, 04 January 2021
1 3026 Mon, 04 January 2021 11:27
By: Michel Cadot
  Fuzzy Matching S-Q-L Sever Taking Fime for 2.4 millions records
By: mohsin_zee on Thu, 31 December 2020
1 6516 Thu, 31 December 2020 14:26
By: Michel Cadot
  sending bulk email in Report 12c?
Report 12c
By: Dhabhu on Wed, 30 December 2020
0 3449 Wed, 30 December 2020 00:21
By: Dhabhu
  Partitoning taking long time
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: sss111ind on Tue, 15 December 2020
5 6446 Thu, 24 December 2020 13:04
By: Solomon Yakobson
  DBMS_HS_PASSTHROUGH - Column Value Truncated
SQL*Plus: Release 11.2.0.1.0 [Server version: 5.7.29-5-log MySQL Community Server - (GPL)]
By: aimy on Mon, 21 December 2020
0 4130 Mon, 21 December 2020 10:38
By: aimy
  ORA 08103 - object no longer exists referring a temporary table
By: NZZ on Fri, 18 December 2020
1 2551 Fri, 18 December 2020 10:56
By: Michel Cadot
  Insufficient privileges?
By: Nicola Farina on Thu, 15 November 2001
5 5455 Fri, 18 December 2020 01:25
By: Michel Cadot
  Mix of Cross and Full Outer Join
https://livesql.oracle.com/apex
By: manubatham20 on Tue, 15 December 2020
5 4723 Wed, 16 December 2020 02:02
By: Michel Cadot
  tab_to_string for longer texts ORA-06502-numeric or value error string
By: rafalbballer on Tue, 01 December 2020
9 7566 Wed, 16 December 2020 01:37
By: rafalbballer
  Ora-06502 error for json_value (merged)
Oracle 12
By: talhaparvaiz@yahoo.com on Sun, 13 December 2020
8 4059 Mon, 14 December 2020 15:07
By: Michel Cadot
  Display Numeric Value from Text Field
Oracle 10 G, Windows7
By: hissam78 on Fri, 11 December 2020
4 6274 Sun, 13 December 2020 00:31
By: Michel Cadot
  XML into one row
12.1.0.2
By: mape on Wed, 09 December 2020
7 4711 Wed, 09 December 2020 07:06
By: mape
  ten-digit hexadecimal number
12.1.0.2.0
By: mape on Tue, 01 December 2020
8 5951 Wed, 09 December 2020 06:10
By: mape
  REGEXP_REPLACE
Oracle 12c
By: sss111ind on Tue, 08 December 2020
2 1856 Tue, 08 December 2020 23:47
By: sss111ind
  string_api package that... has no body?
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows
By: Darth Waiter on Wed, 02 December 2020
22 8181 Tue, 08 December 2020 18:28
By: flyboy
  Help for a noobie!
By: nail3r on Thu, 03 December 2020
1 4246 Thu, 03 December 2020 04:17
By: Michel Cadot
  Need help to rewrite the query
11G
By: nikhiljuneja@gmail.com on Mon, 30 November 2020
4 3451 Tue, 01 December 2020 00:27
By: nikhiljuneja@gmail.com
  week start from saturday
oracle 10g, windows 7
By: hissam78 on Sat, 28 November 2020
7 4958 Tue, 01 December 2020 00:17
By: Michel Cadot
  How to convert JSON into XML in Oracle 10g
By: Mark70 on Mon, 30 November 2020
1 3216 Mon, 30 November 2020 05:45
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: Mon Apr 19 20:01:18 CDT 2021