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	22972	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	266658	Tue, 06 November 2018 14:17 By: Solomon Yakobson
	Data Dictionary for Collection Bind variables Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: saipradyumn on Tue, 19 October 2021	0	251	Tue, 19 October 2021 04:38 By: saipradyumn
	Long query with WITH not responding Ora 11.2.0.3.0 By: Reversi72 on Mon, 11 October 2021	22	8971	Mon, 18 October 2021 12:04 By: Michel Cadot
	DBMS_JOB.SUBMIT not appearing Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: saipradyumn on Mon, 04 October 2021	6	6290	Mon, 18 October 2021 03:12 By: saipradyumn
	Select Query suggestion Oracle 12c By: akssre on Sun, 17 October 2021	5	2279	Mon, 18 October 2021 00:33 By: Michel Cadot
Truncate SYS.AUD$ Using dbms_audit_mgmt has been moved to Server Administration by the moderator.
	transpose rows into columns oracle By: suji6281 on Thu, 30 September 2021	31	13000	Sun, 17 October 2021 13:01 By: Michel Cadot
	Is there a way to create a materialized view with datatype and length? By: joy_division on Fri, 08 October 2021	7	5126	Fri, 08 October 2021 15:37 By: Solomon Yakobson
	Retrieve font name available in OS using sql plus Windows 7, Oracle 10g XE By: lock_heart on Wed, 04 December 2013	16	5945	Wed, 06 October 2021 23:28 By: MaaM
	REGEXP_LIKE 12c ENT Edition 12.2.0.1.0 By: vippysharma on Mon, 04 October 2021	2	3527	Mon, 04 October 2021 06:27 By: vippysharma
	SQL Query- Connect By (merged) 11g By: sayan13 on Tue, 28 September 2021	3	6665	Tue, 28 September 2021 01:28 By: Michel Cadot
	Extract string between 2 text 11gr2 By: guddu_12 on Sun, 26 September 2021	6	4443	Sun, 26 September 2021 10:22 By: guddu_12
	Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path Oracle R12 By: kjnf505 on Mon, 20 September 2021	1	2554	Tue, 21 September 2021 20:12 By: EdStevens
	member and collection type oracle 12.1 By: pointers on Wed, 08 September 2021	4	10750	Sat, 11 September 2021 01:57 By: pointers
	Slab Level query (merged) Oracle 11 By: annu-agi on Mon, 06 September 2021	6	10191	Tue, 07 September 2021 03:00 By: annu-agi
	Function Finding multiple occurrences of a string 19c By: Unclefool on Mon, 06 September 2021	4	6646	Mon, 06 September 2021 21:23 By: Unclefool
	query to display employee whose code is 03 is not inserted 11g By: glmjoy on Sat, 04 September 2021	6	6962	Sat, 04 September 2021 13:46 By: glmjoy
	Write an SQL query to report the students (student_id, student_name) being “quiet” in ALL exams. A “ By: vritik on Fri, 03 September 2021	1	5465	Fri, 03 September 2021 11:54 By: Michel Cadot
	Error ocurred calling a Web Service using UTL_HTTP Oracle Database, 10g Enterprise Edition Release 10.2.0.4.0, HP-UX By: gusmenp on Thu, 27 June 2013	6	17063	Tue, 31 August 2021 07:37 By: mohsin0012
	Duplicating Excel "RATE" function in Oracle Oracle 11.2 By: Primordial on Wed, 18 February 2015	19	20226	Mon, 30 August 2021 16:24 By: eleny
	Fire triggers on a nested_table By: ryouga82 on Fri, 27 August 2021	2	10245	Sun, 29 August 2021 11:33 By: Solomon Yakobson
	Oracle Invalid hint 19c By: Unclefool on Fri, 27 August 2021	1	11580	Sat, 28 August 2021 01:27 By: John Watson
	Generate Unique Grouping ID Oracle 12c By: Manoj.Gupta.91 on Thu, 26 August 2021	3	8790	Fri, 27 August 2021 01:13 By: _jum
	About REF datatype 10.2 to 19 By: Michel Cadot on Fri, 20 August 2021	11	11441	Mon, 23 August 2021 01:15 By: Michel Cadot
	Oracle INSERT, SELECT, NOT EXISTS primary key 19c By: Unclefool on Sat, 21 August 2021	3	8449	Sun, 22 August 2021 14:21 By: Andrey_R
	Oracle cte multiple rows (3 merged) 19c By: Unclefool on Thu, 19 August 2021	2	7930	Thu, 19 August 2021 07:51 By: Unclefool
	Oracle procedure passing NULL in DATE parameters 19c By: Unclefool on Wed, 18 August 2021	2	7237	Wed, 18 August 2021 13:18 By: Unclefool
	Creating time rows that doesn't cross midnight 19c By: Unclefool on Tue, 17 August 2021	4	5784	Wed, 18 August 2021 08:36 By: Unclefool
	How to execute dynamically the permission grant using AWS RDS custom procedure (merged) Oracle rds 12.1.0.v1 By: kesavansundaram on Tue, 17 August 2021	2	5473	Wed, 18 August 2021 00:05 By: Michel Cadot
	SYSAUX IMPACT ON PERFORMANCE 12c ENT Edition 12.2.0.1.0 By: vippysharma on Mon, 16 August 2021	1	1369	Tue, 17 August 2021 00:17 By: Michel Cadot
	Creating rows every 5 minutes without overlap 19c By: Unclefool on Mon, 16 August 2021	2	2432	Mon, 16 August 2021 19:53 By: Unclefool
	Table type collection in SELECT Oracle 11g By: sinpeak on Thu, 05 August 2021	2	8921	Wed, 11 August 2021 01:20 By: sinpeak
	BMP not correctly formated with UTF8 Characterset Database 12c By: Usman Tabassum on Thu, 05 August 2021	3	10835	Fri, 06 August 2021 04:16 By: Michel Cadot
	Question about databses By: itmasterw on Wed, 04 August 2021	4	9544	Wed, 04 August 2021 11:04 By: itmasterw
	QUERY TO DISPLAY EDUCATION 11g By: glmjoy on Wed, 28 July 2021	10	12697	Wed, 28 July 2021 09:14 By: EdStevens
	Execution Plan of query Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 27 July 2021	2	13121	Tue, 27 July 2021 07:03 By: saipradyumn
	Prime Generation Logic using in single Query Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Thu, 22 July 2021	3	5301	Thu, 22 July 2021 14:13 By: Michel Cadot
	Statement Level trigger - After Insert/Update 11g By: revathitirun on Wed, 07 July 2021	4	16856	Thu, 22 July 2021 11:42 By: Michel Cadot
	How to stop swapping in EXCHANGE PARTITION PLSQL 12.1.0.2.0 By: gopalMisra on Fri, 16 July 2021	7	8724	Mon, 19 July 2021 02:24 By: Michel Cadot