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	35242	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	47	326588	Sun, 29 January 2023 19:35 By: mathguy
	Grouping similar strings together using UTL_MATCH Jaro-Winkler 12.1.0.1 By: OraFerro on Wed, 27 September 2023	3	236	Fri, 29 September 2023 12:14 By: mathguy
	Improve select with inner JOIN Oracle 12, SQL, Linux By: carlino70 on Thu, 28 September 2023	6	2104	Fri, 29 September 2023 09:23 By: carlino70
	Inserted JSON into Column is being Truncated Oracle, 19.0.0.0.0, Linux By: Duane on Wed, 27 September 2023	10	1830	Thu, 28 September 2023 19:01 By: Duane
Need help to setup NLS_LANG when my PLSQL Developer executes has been moved to Client Tools by the moderator.
	Count non workink days between two dates, from calendar table Impala - SQL By: Nicha on Wed, 27 September 2023	5	2253	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	1600	Wed, 27 September 2023 23:31 By: OraFerro
	case statement giving an error oracle19c By: shrinika on Thu, 21 September 2023	2	9335	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	901	Sun, 24 September 2023 00:56 By: John Watson
	Custom Calendar query By: msinha8 on Fri, 22 September 2023	2	6615	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	8673	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	9333	Tue, 19 September 2023 08:30 By: Solomon Yakobson
	Update statement with INNER JOIN oracle By: suji6281 on Fri, 15 September 2023	3	9136	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	17838	Thu, 07 September 2023 08:54 By: Arinaen
	Jaro-Winkler similarity for 9i By: Barbara Boehmer on Thu, 16 December 2010	10	20137	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	19121	Fri, 01 September 2023 14:34 By: Alien
	Remove duplicates Oracle 10g By: arun888 on Thu, 31 August 2023	1	7168	Thu, 31 August 2023 05:13 By: Littlefoot
	Getting Error - ORA-01858 Windows 10 By: Qrry on Fri, 25 August 2023	1	9680	Fri, 25 August 2023 14:58 By: Barbara Boehmer
	Data Extraction Oracle 12C By: ssharmila on Fri, 11 June 2021	3	13709	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	12448	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	12446	Tue, 22 August 2023 08:15 By: Barbara Boehmer
	Numbers are returned reversed on query (Hebrew.. ) By: liorke76 on Thu, 17 August 2023	2	10954	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	10597	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	7583	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	6435	Wed, 16 August 2023 15:04 By: Barbara Boehmer
	Ranking account and customer balances 19c By: Unclefool on Tue, 15 August 2023	8	4761	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	4868	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	7932	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	5899	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	5523	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	10546	Tue, 01 August 2023 11:46 By: born2achieve
	Merge using rownum 12.1.0.1 By: OraFerro on Mon, 31 July 2023	2	8977	Tue, 01 August 2023 05:18 By: OraFerro
	Display 3rd highest salary (join) 19c By: Unclefool on Mon, 31 July 2023	5	7269	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	15619	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	8659	Thu, 20 July 2023 21:46 By: mathguy
	Duplicate Rows 19C By: deepakdot on Wed, 21 June 2023	4	16854	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	9976	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	19286	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	6667	Mon, 17 July 2023 13:13 By: Solomon Yakobson