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
  Grouping similar strings together using UTL_MATCH Jaro-Winkler
12.1.0.1
By: OraFerro on Wed, 27 September 2023
7 14048 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 10477 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 4925 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 3255 Wed, 27 September 2023 23:31
By: OraFerro
  case statement giving an error
oracle19c
By: shrinika on Thu, 21 September 2023
2 11163 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 2119 Sun, 24 September 2023 00:56
By: John Watson
  Custom Calendar query
By: msinha8 on Fri, 22 September 2023
2 7812 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 10016 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 10907 Tue, 19 September 2023 08:30
By: Solomon Yakobson
  Update statement with INNER JOIN
oracle
By: suji6281 on Fri, 15 September 2023
3 10529 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 19552 Thu, 07 September 2023 08:54
By: Arinaen
  Jaro-Winkler similarity for 9i
By: Barbara Boehmer on Thu, 16 December 2010
10 22254 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 20697 Fri, 01 September 2023 14:34
By: Alien
  Remove duplicates
Oracle 10g
By: arun888 on Thu, 31 August 2023
1 8627 Thu, 31 August 2023 05:13
By: Littlefoot
icon4.gif Getting Error - ORA-01858
Windows 10
By: Qrry on Fri, 25 August 2023
1 10727 Fri, 25 August 2023 14:58
By: Barbara Boehmer
  Data Extraction
Oracle 12C
By: ssharmila on Fri, 11 June 2021
3 14876 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 15112 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 13401 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 12048 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 11887 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 8860 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 7670 Wed, 16 August 2023 15:04
By: Barbara Boehmer
  Ranking account and customer balances
19c
By: Unclefool on Tue, 15 August 2023
8 5842 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 6124 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 8995 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 6870 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 6572 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 11596 Tue, 01 August 2023 11:46
By: born2achieve
  Merge using rownum
12.1.0.1
By: OraFerro on Mon, 31 July 2023
2 9902 Tue, 01 August 2023 05:18
By: OraFerro
  Display 3rd highest salary (join)
19c
By: Unclefool on Mon, 31 July 2023
5 8196 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 16829 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 9565 Thu, 20 July 2023 21:46
By: mathguy
  Duplicate Rows
19C
By: deepakdot on Wed, 21 June 2023
4 17874 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 10666 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 20223 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 7509 Mon, 17 July 2023 13:13
By: Solomon Yakobson
  DBMS LDAP package
Oracle DB 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Sun Solaris
By: vinayrajn on Mon, 26 June 2023
2 15340 Mon, 26 June 2023 16:13
By: vinayrajn
icon5.gif How create such attached table by travelling view and its dependent objects
Oracle 18c
By: mm_kanish05 on Thu, 22 June 2023
6 15598 Sat, 24 June 2023 13:19
By: Barbara Boehmer
  Oracle function to get account balance
19c
By: Unclefool on Fri, 23 June 2023
2 12981 Fri, 23 June 2023 11:30
By: Michel Cadot
  Letter and TIMESTAMP CONCAT (INSERT error)
19c
By: Unclefool on Sat, 17 June 2023
4 8783 Sat, 17 June 2023 10:31
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: Mon Feb 26 01:47:33 CST 2024