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
  Partition
19c
By: babuknb on Thu, 07 December 2023
6 27167 Sun, 07 January 2024 12:26
By: babuknb
  Create Partition and Sub-Partition
By: ace_friends22 on Wed, 27 December 2023
8 25900 Wed, 27 December 2023 07:33
By: Solomon Yakobson
icon5.gif problem with sql passthru syntax - get "FROM keyword not found where expected (4 merged)
MS Access query passthru to Oracle
By: Bob Alston on Fri, 22 December 2023
7 41448 Tue, 26 December 2023 22:47
By: flyboy
  Problem in pivot query
12.1.0.1
By: OraFerro on Fri, 15 December 2023
7 26400 Thu, 21 December 2023 12:19
By: Barbara Boehmer
  Help need in writing query to get JSON format output
Oracle 19c
By: pr76666 on Mon, 30 January 2023
10 35814 Thu, 14 December 2023 06:51
By: annabelle67
  Created schedule based on date conditions
12.1.0.1
By: OraFerro on Wed, 06 December 2023
8 19218 Tue, 12 December 2023 04:42
By: OraFerro
  sql Qurey
Oracle 10g
By: amjadem@gmail.com on Sat, 02 December 2023
5 13834 Sat, 02 December 2023 11:52
By: Solomon Yakobson
  Transform row data into columns
Oracle 19c, Linux
By: rajiv.oradev on Wed, 22 November 2023
20 20664 Wed, 29 November 2023 20:52
By: Solomon Yakobson
  Sequentially update a column with a decrementing value
By: madfeen on Fri, 24 November 2023
11 16233 Mon, 27 November 2023 02:23
By: madfeen
  SQL QUERY
11g
By: glmjoy on Sat, 25 November 2023
4 14580 Sat, 25 November 2023 05:12
By: glmjoy
  PL/SQL wrapper error
By: subratd on Tue, 06 March 2007
9 30752 Thu, 23 November 2023 03:42
By: NevemTeve
  Help with query returning JSON
Oracle, 19.0.0.0.0, Linux
By: Duane on Thu, 16 November 2023
7 14045 Thu, 16 November 2023 11:01
By: Duane
  Recursive subquery factoring
11.2.0.30
By: Amine on Mon, 06 November 2023
7 16836 Tue, 07 November 2023 14:30
By: mathguy
  Create a oracle function that parse a string to date time when not null
20.4.1.407
By: DorababuMeka on Mon, 30 October 2023
7 13723 Mon, 30 October 2023 08:09
By: Barbara Boehmer
  Unable to compile procedure
ORACLE
By: DorababuMeka on Thu, 26 October 2023
7 9227 Fri, 27 October 2023 05:44
By: Michel Cadot
  Need a pl/sql block to be entered in existing package
"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0"
By: indupriyav_2023 on Thu, 05 October 2023
3 22789 Thu, 05 October 2023 15:11
By: Barbara Boehmer
  Improve select with inner JOIN
Oracle 12, SQL, Linux
By: carlino70 on Thu, 28 September 2023
12 23600 Mon, 02 October 2023 13:20
By: carlino70
  Grouping similar strings together using UTL_MATCH Jaro-Winkler
12.1.0.1
By: OraFerro on Wed, 27 September 2023
7 14592 Sun, 01 October 2023 03:57
By: Barbara Boehmer
  Inserted JSON into Column is being Truncated
Oracle, 19.0.0.0.0, Linux
By: Duane on Wed, 27 September 2023
10 10887 Thu, 28 September 2023 19:01
By: Duane
  Count non workink days between two dates, from calendar table
Impala - SQL
By: Nicha on Wed, 27 September 2023
5 5277 Thu, 28 September 2023 05:23
By: Nicha
  Deleting referenced tables based on child table criteria
12.1.0.1
By: OraFerro on Tue, 26 September 2023
6 3637 Wed, 27 September 2023 23:31
By: OraFerro
  case statement giving an error
oracle19c
By: shrinika on Thu, 21 September 2023
2 11587 Tue, 26 September 2023 10:26
By: shrinika
  Tuning of the update statement in oracle
By: chavva.kiru@gmail.com on Sat, 23 September 2023
2 2445 Sun, 24 September 2023 00:56
By: John Watson
  Custom Calendar query
By: msinha8 on Fri, 22 September 2023
2 8133 Fri, 22 September 2023 08:32
By: Michel Cadot
  Jpeg Image thumbnail,height,width properties need in Oracle 19c
oracle19c , os:oracle linux
By: mvrkr44 on Wed, 20 September 2023
1 10399 Wed, 20 September 2023 06:51
By: John Watson
  how to get employee in and out time for generated query based on first in and last out
Oracle 11g
By: murad060 on Mon, 18 September 2023
8 11365 Tue, 19 September 2023 08:30
By: Solomon Yakobson
  Update statement with INNER JOIN
oracle
By: suji6281 on Fri, 15 September 2023
3 10975 Fri, 15 September 2023 11:10
By: Solomon Yakobson
  Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized
11.2.0.4.0
By: skfaheem024 on Thu, 08 September 2022
4 20104 Thu, 07 September 2023 08:54
By: Arinaen
  Jaro-Winkler similarity for 9i
By: Barbara Boehmer on Thu, 16 December 2010
10 22766 Sat, 02 September 2023 15:09
By: Barbara Boehmer
  ora-01775 looping chain of synonyms in forms 6i (merged)
menu item enable disable
By: mfahimaamirgmailcom on Fri, 01 September 2023
2 21176 Fri, 01 September 2023 14:34
By: Alien
  Remove duplicates
Oracle 10g
By: arun888 on Thu, 31 August 2023
1 9005 Thu, 31 August 2023 05:13
By: Littlefoot
icon4.gif Getting Error - ORA-01858
Windows 10
By: Qrry on Fri, 25 August 2023
1 11090 Fri, 25 August 2023 14:58
By: Barbara Boehmer
  Data Extraction
Oracle 12C
By: ssharmila on Fri, 11 June 2021
3 15310 Fri, 25 August 2023 00:47
By: mathguy
  ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object
DB19.20
By: John Watson on Wed, 23 August 2023
3 16334 Wed, 23 August 2023 13:07
By: Solomon Yakobson
  Pivot : asign columns names
11.2.0.3
By: Amine on Tue, 22 August 2023
1 13782 Tue, 22 August 2023 08:15
By: Barbara Boehmer
icon5.gif Numbers are returned reversed on query (Hebrew.. )
By: liorke76 on Thu, 17 August 2023
2 12416 Thu, 17 August 2023 14:39
By: mathguy
  High Storage Consumption for LOB
Oracle Database - Enterprise Edition
By: drukpa on Fri, 11 August 2023
5 12231 Thu, 17 August 2023 07:11
By: John Watson
  check the integrity of a field between 3 or more tables - SQL Oracle
Oracle 11g
By: Nicha on Wed, 16 August 2023
10 9217 Wed, 16 August 2023 17:59
By: Nicha
  How to access URL's from your database that are accessible from your browser
Oracle DB 19c
By: kjcook on Wed, 16 August 2023
3 8095 Wed, 16 August 2023 15:04
By: Barbara Boehmer
  Ranking account and customer balances
19c
By: Unclefool on Tue, 15 August 2023
8 6271 Wed, 16 August 2023 13:52
By: Unclefool
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 May 24 11:14:54 CDT 2024