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
  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 13337 Mon, 30 October 2023 08:09
By: Barbara Boehmer
  Unable to compile procedure
ORACLE
By: DorababuMeka on Thu, 26 October 2023
7 8872 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 22488 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 23279 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 14205 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 10559 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 5000 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 3336 Wed, 27 September 2023 23:31
By: OraFerro
  case statement giving an error
oracle19c
By: shrinika on Thu, 21 September 2023
2 11286 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 2173 Sun, 24 September 2023 00:56
By: John Watson
  Custom Calendar query
By: msinha8 on Fri, 22 September 2023
2 7876 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 10103 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 10996 Tue, 19 September 2023 08:30
By: Solomon Yakobson
  Update statement with INNER JOIN
oracle
By: suji6281 on Fri, 15 September 2023
3 10640 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 19678 Thu, 07 September 2023 08:54
By: Arinaen
  Jaro-Winkler similarity for 9i
By: Barbara Boehmer on Thu, 16 December 2010
10 22381 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 20824 Fri, 01 September 2023 14:34
By: Alien
  Remove duplicates
Oracle 10g
By: arun888 on Thu, 31 August 2023
1 8734 Thu, 31 August 2023 05:13
By: Littlefoot
icon4.gif Getting Error - ORA-01858
Windows 10
By: Qrry on Fri, 25 August 2023
1 10819 Fri, 25 August 2023 14:58
By: Barbara Boehmer
  Data Extraction
Oracle 12C
By: ssharmila on Fri, 11 June 2021
3 14986 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 15497 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 13479 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 12149 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 11967 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 8929 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 7772 Wed, 16 August 2023 15:04
By: Barbara Boehmer
  Ranking account and customer balances
19c
By: Unclefool on Tue, 15 August 2023
8 5935 Wed, 16 August 2023 13:52
By: Unclefool
  Repeat Rows based on column value (merged by CM)
By: cplib on Wed, 19 May 2010
15 6214 Tue, 15 August 2023 16:54
By: M117
  Last N TRANSACTIONS for each customer (syntax error)
19c
By: Unclefool on Tue, 08 August 2023
6 9079 Tue, 08 August 2023 14:26
By: Barbara Boehmer
  Log errors reject limit unlimited
Oracle 12.2
By: pointers on Tue, 08 August 2023
3 6948 Tue, 08 August 2023 11:27
By: Solomon Yakobson
  DBMS_SQL.PARSE
Forms 6i Oracle Database 19c
By: chat2raj.s on Mon, 07 August 2023
7 6659 Tue, 08 August 2023 08:26
By: Solomon Yakobson
  How to Delimit the Large comma separated string - Oracle Procedure
oracle 12c
By: born2achieve on Mon, 31 July 2023
6 11657 Tue, 01 August 2023 11:46
By: born2achieve
  Merge using rownum
12.1.0.1
By: OraFerro on Mon, 31 July 2023
2 9986 Tue, 01 August 2023 05:18
By: OraFerro
  Display 3rd highest salary (join)
19c
By: Unclefool on Mon, 31 July 2023
5 8302 Mon, 31 July 2023 13:13
By: Solomon Yakobson
  Updating a Hijri date in oracle date column
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: chat2raj.s on Thu, 20 July 2023
4 16996 Thu, 27 July 2023 23:56
By: chat2raj.s
  Finding initial, final, in_between, and initial_and_final events
By: manubatham20 on Thu, 20 July 2023
8 9628 Thu, 20 July 2023 21:46
By: mathguy
  Duplicate Rows
19C
By: deepakdot on Wed, 21 June 2023
4 17979 Tue, 18 July 2023 20:01
By: mathguy
  Question on Pivot columns
Oracle 19.0.0.0.0
By: manoj12 on Mon, 10 July 2023
5 10738 Tue, 18 July 2023 13:02
By: mathguy
  order by union query
Form 6i, Database10g
By: shahzad-ul-hasan on Wed, 28 June 2023
7 20309 Tue, 18 July 2023 12:55
By: mathguy
  DDL generation
Oracle Database 19.10 Linux x86_64
By: smunir362 on Sat, 15 July 2023
5 7605 Mon, 17 July 2023 13:13
By: Solomon Yakobson
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: Thu Mar 28 03:57:41 CDT 2024