OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	1	35137	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	47	326436	Sun, 29 January 2023 19:35 By: mathguy
Custom Calendar query By: msinha8 on Fri, 22 September 2023	2	147	Fri, 22 September 2023 08:32 By: Michel Cadot
case statement giving an error oracle19c By: shrinika on Thu, 21 September 2023	1	1849	Thu, 21 September 2023 12:10 By: Barbara Boehmer
Jpeg Image thumbnail,height,width properties need in Oracle 19c oracle19c , os:oracle linux By: mvrkr44 on Wed, 20 September 2023	1	2376	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	5753	Tue, 19 September 2023 08:30 By: Solomon Yakobson
Update statement with INNER JOIN oracle By: suji6281 on Fri, 15 September 2023	3	9027	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	17721	Thu, 07 September 2023 08:54 By: Arinaen
Jaro-Winkler similarity for 9i By: Barbara Boehmer on Thu, 16 December 2010	10	19883	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	19001	Fri, 01 September 2023 14:34 By: Alien
Remove duplicates Oracle 10g By: arun888 on Thu, 31 August 2023	1	7049	Thu, 31 August 2023 05:13 By: Littlefoot
Getting Error - ORA-01858 Windows 10 By: Qrry on Fri, 25 August 2023	1	9569	Fri, 25 August 2023 14:58 By: Barbara Boehmer
Data Extraction Oracle 12C By: ssharmila on Fri, 11 June 2021	3	13562	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	12305	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	12354	Tue, 22 August 2023 08:15 By: Barbara Boehmer
Numbers are returned reversed on query (Hebrew.. ) By: liorke76 on Thu, 17 August 2023	2	10869	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	10485	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	7482	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	6323	Wed, 16 August 2023 15:04 By: Barbara Boehmer
Ranking account and customer balances 19c By: Unclefool on Tue, 15 August 2023	8	4688	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	4784	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	7845	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	5821	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	5431	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	10457	Tue, 01 August 2023 11:46 By: born2achieve
Merge using rownum 12.1.0.1 By: OraFerro on Mon, 31 July 2023	2	8904	Tue, 01 August 2023 05:18 By: OraFerro
Display 3rd highest salary (join) 19c By: Unclefool on Mon, 31 July 2023	5	7194	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	15495	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	8587	Thu, 20 July 2023 21:46 By: mathguy
Duplicate Rows 19C By: deepakdot on Wed, 21 June 2023	4	16728	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	9901	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	19179	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	6592	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	14429	Mon, 26 June 2023 16:13 By: vinayrajn
How create such attached table by travelling view and its dependent objects Oracle 18c By: mm_kanish05 on Thu, 22 June 2023	6	14618	Sat, 24 June 2023 13:19 By: Barbara Boehmer
Oracle function to get account balance 19c By: Unclefool on Fri, 23 June 2023	2	12239	Fri, 23 June 2023 11:30 By: Michel Cadot
Letter and TIMESTAMP CONCAT (INSERT error) 19c By: Unclefool on Sat, 17 June 2023	4	8127	Sat, 17 June 2023 10:31 By: Unclefool
Query to split date count into multiple rows and level that over weeks . By: itzkashi on Wed, 14 June 2023	2	13923	Thu, 15 June 2023 09:45 By: itzkashi
What is the difference between MINUS and LEFT outer join Oracle 10g, Windows By: nathb on Fri, 27 July 2012	10	19795	Wed, 24 May 2023 08:06 By: Solomon Yakobson
check all the distinct value match oracle 10g windows By: guddu_12 on Wed, 17 May 2023	9	11380	Thu, 18 May 2023 08:06 By: Michel Cadot