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
  Is there a better way to do this in Oracle - Generate series with other entries
Oracle >= 11.2
By: dragam on Thu, 14 April 2022
1 7833 Thu, 14 April 2022 09:05
By: Michel Cadot
  question on solution provided
oracle 19c(19.0.0.0.0)
By: manoj12 on Wed, 13 April 2022
0 8678 Wed, 13 April 2022 20:35
By: manoj12
  Help Needed in Oracle Referenced Column DataType
oracle 19c
By: born2achieve on Mon, 11 April 2022
3 9149 Tue, 12 April 2022 09:27
By: EdStevens
  Oracle JOIN tables
Oracle 19.2
By: Unclefool on Mon, 11 April 2022
4 6717 Mon, 11 April 2022 14:35
By: Unclefool
  Find Difference between 2 columns along with difference data
Oracle 12g
By: abhayman on Thu, 31 March 2022
6 12211 Mon, 04 April 2022 02:04
By: piripicchio
  XML Generation
Oracle 11g, XP
By: rajiv.oradev on Thu, 17 March 2022
13 23197 Sat, 02 April 2022 14:21
By: Solomon Yakobson
  Data not sorted
Oracle 19.2
By: Unclefool on Fri, 01 April 2022
2 10849 Fri, 01 April 2022 07:35
By: Unclefool
icon9.gif Oracle Update to get data from other tables using join
By: benoitS on Fri, 01 April 2022
2 10290 Fri, 01 April 2022 07:10
By: Solomon Yakobson
  Remove empty tags from XML
Oracle 11g, XP
By: rajiv.oradev on Thu, 31 March 2022
0 8973 Thu, 31 March 2022 15:33
By: rajiv.oradev
  ORA-01722 Invalid Number for numeric values.
Oracle 12c
By: Dhritman on Fri, 25 March 2022
9 11449 Fri, 25 March 2022 05:28
By: Solomon Yakobson
  DB last date
12.1.0.1.0
By: OraFerro on Wed, 23 March 2022
4 11618 Thu, 24 March 2022 07:34
By: EdStevens
  Code not waiting for REFCURSOR
Oracle 12c
By: IanC on Thu, 17 March 2022
5 14594 Tue, 22 March 2022 05:50
By: IanC
  Select Query suggestion
Oracle 12c
By: akssre on Tue, 15 March 2022
9 12139 Thu, 17 March 2022 05:22
By: Solomon Yakobson
  Pass a "Cursor XXXX is" statement to another procedure
Oracle, 12.2, Unix
By: Duane on Mon, 14 March 2022
3 8917 Tue, 15 March 2022 17:56
By: Solomon Yakobson
  Oracle calculate hours between timestamps
19.2
By: Unclefool on Thu, 10 March 2022
3 10594 Thu, 10 March 2022 17:30
By: EdStevens
  Let's promote them all !
11.2.0.3
By: Amine on Fri, 18 February 2022
8 14251 Wed, 09 March 2022 15:01
By: Amine
  Help Needed in Date Variable
By: born2achieve on Mon, 21 February 2022
1 12669 Tue, 22 February 2022 00:34
By: Michel Cadot
  Getting ORA-24374 , when using function in with query (merged)
PLSQL 12.1.0.2.0
By: gopalMisra on Tue, 15 February 2022
13 12866 Mon, 21 February 2022 07:16
By: gopalMisra
  SQL -Report missing string when running a query
Oracle 11 windows 10
By: Kevin1967 on Wed, 16 February 2022
4 7138 Sat, 19 February 2022 00:26
By: Michel Cadot
  Facing issie in 19c
By: nishant87 on Thu, 17 February 2022
5 7552 Thu, 17 February 2022 08:16
By: EdStevens
  Putting a row with a particular value on top of a sort
Oracle 21, Windows 10
By: orHooha on Wed, 09 February 2022
3 8653 Wed, 09 February 2022 20:59
By: orHooha
  query
oracle11g
By: Norfree on Wed, 02 February 2022
4 14640 Tue, 08 February 2022 06:49
By: Solomon Yakobson
  record count between one hour
Oracle 19c
By: bkbora on Fri, 04 February 2022
3 8405 Sun, 06 February 2022 06:21
By: Solomon Yakobson
  Oracle case INSERT statement
19.2
By: Unclefool on Fri, 04 February 2022
6 7983 Sat, 05 February 2022 09:14
By: EdStevens
  Print value in table columns dynamically
By: dancko on Sun, 30 January 2022
5 17254 Wed, 02 February 2022 13:10
By: Michel Cadot
  ORA-04068: existing state of packages has been discarded
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat
By: fixxxer on Fri, 30 August 2019
7 15061 Wed, 02 February 2022 03:38
By: fixxxer
  transpose logic
oracle
By: suji6281 on Tue, 25 January 2022
6 14412 Sat, 29 January 2022 18:31
By: Solomon Yakobson
  ORA 00922 MISSING OR INVALID OPTION
ORACLE 12C , ORACLE FORMS AND REPORTS 12C
By: lacchhii on Mon, 24 January 2022
2 7740 Tue, 25 January 2022 21:50
By: lacchhii
  Hex Value to Base64 Value Convertion
SQL PL/SQL
By: Khader Hussain on Mon, 24 January 2022
2 5723 Mon, 24 January 2022 03:30
By: Khader Hussain
  Dynamically pass table name in PLSQL
Oracle client 18.0
By: 345678 on Sat, 22 January 2022
6 6927 Mon, 24 January 2022 03:16
By: 345678
  PL/SQL escaping variable with a single quote
19.2
By: Unclefool on Tue, 18 January 2022
2 11240 Wed, 19 January 2022 06:28
By: Unclefool
  Unexpected Grants To Public
By: Gogetter on Wed, 12 January 2022
3 15681 Wed, 12 January 2022 03:21
By: Gogetter
  Oracle generate from-to DATE ranges and group by
19.2
By: Unclefool on Fri, 07 January 2022
2 18084 Fri, 07 January 2022 06:52
By: Unclefool
  Defining Variables in the Package Spec
Oracle, 12.2, Unix
By: Duane on Thu, 06 January 2022
3 16833 Fri, 07 January 2022 06:36
By: Frank
  Query Performance
Orcale 12-c
By: RGFJ on Thu, 06 January 2022
3 15658 Fri, 07 January 2022 06:34
By: Frank
  Two MAX Functions in a Single SELECT
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
By: whdyck on Thu, 23 December 2021
12 25799 Wed, 05 January 2022 07:33
By: Frank
  Oracle porting a natural join
19.2
By: Unclefool on Sun, 26 December 2021
2 15499 Tue, 28 December 2021 02:27
By: John Watson
  How to update the nested array in json clob column data using plsql..?
By: jeevetha on Thu, 23 December 2021
2 15816 Fri, 24 December 2021 08:10
By: Solomon Yakobson
  Split a row into multiple rows
Oracle
By: syam09 on Thu, 23 December 2021
1 11760 Thu, 23 December 2021 08:08
By: Michel Cadot
  Flatten table to get unique VALUES
19.2
By: Unclefool on Thu, 16 December 2021
9 14949 Mon, 20 December 2021 11:22
By: John Watson
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: Tue Mar 19 01:55:53 CDT 2024