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	23937	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	271555	Tue, 06 November 2018 14:17 By: Solomon Yakobson
PDF upload as an attachment? has been moved to Forms by the moderator.
PDF upload as an attachment? (3 merged) has been moved to Forms by the moderator.
	Oracle Display parent, child, grandchild hierarchy 19.2 By: Unclefool on Sat, 04 December 2021	4	3215	Sun, 05 December 2021 11:05 By: Unclefool
	to_date in where clause By: shahzad-ul-hasan on Fri, 26 November 2021	15	10179	Sun, 05 December 2021 02:19 By: OraFerro
	DBA_HIST_SQLTEXT string buffer too small Oracle 12.1 By: db_senior on Sat, 27 November 2021	1	7152	Sat, 27 November 2021 04:20 By: Michel Cadot
	Oracle regex_substr parsing a clob 19.2 By: Unclefool on Tue, 23 November 2021	1	4392	Tue, 23 November 2021 11:32 By: Solomon Yakobson
	Data history 11.2.0.3 By: Amine on Thu, 04 November 2021	20	15115	Tue, 09 November 2021 18:14 By: Solomon Yakobson
	Dates integrity 11.2.0.3 By: Amine on Mon, 08 November 2021	4	17764	Tue, 09 November 2021 03:09 By: Amine
	Sequence number to be entered by a user Oracle 12c, O/S: Windows 10 pro By: buggleboy007 on Fri, 05 November 2021	2	16271	Sat, 06 November 2021 09:26 By: buggleboy007
	Select value from multiple dates Oracle 10g By: shahzad-ul-hasan on Thu, 04 November 2021	4	4857	Thu, 04 November 2021 13:49 By: EdStevens
	Days Query 11G By: glmjoy on Wed, 27 October 2021	4	6681	Thu, 04 November 2021 11:23 By: Michel Cadot
	How to get monthly average sum By: Lim on Mon, 01 November 2021	15	4209	Tue, 02 November 2021 04:27 By: Michel Cadot
	Oracle stored procedure with complex conditions By: sud_oracle on Sun, 31 October 2021	4	2893	Mon, 01 November 2021 10:25 By: sud_oracle
	Parsing query Oracle 11g By: akull on Mon, 01 November 2021	2	1989	Mon, 01 November 2021 08:35 By: akull
	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	9	11881	Fri, 29 October 2021 15:35 By: Andrey_R
	Oracle SQL a=b and b=a Oracle 12C By: rahul1982 on Fri, 29 October 2021	3	4355	Fri, 29 October 2021 14:25 By: EdStevens
	Long query with WITH not responding Ora 11.2.0.3.0 By: Reversi72 on Mon, 11 October 2021	23	15985	Fri, 29 October 2021 04:44 By: Reversi72
	Unable to take backup of a table Oracle, 18.0.0.0.0, CentOS Linux release 7.8.2003 (Core) By: BalajiDBA on Thu, 28 October 2021	8	5547	Fri, 29 October 2021 00:43 By: Michel Cadot
	transpose rows into columns oracle By: suji6281 on Thu, 30 September 2021	37	22041	Thu, 28 October 2021 22:03 By: Sekhar6617
	How to substract 2 varchar2 dates (YYYYMMDDHH24MMSS) in oracle? By: mmm286 on Tue, 26 October 2021	5	2511	Wed, 27 October 2021 08:51 By: Andrey_R
	Who call me all versions from 11g to 19c By: Michel Cadot on Fri, 22 October 2021	11	7432	Sun, 24 October 2021 03:26 By: Michel Cadot
	Prefix data into an existing clob 19.2 By: Unclefool on Sat, 23 October 2021	1	3287	Sat, 23 October 2021 12:03 By: Solomon Yakobson
	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	9861	Mon, 18 October 2021 03:12 By: saipradyumn
	Select Query suggestion Oracle 12c By: akssre on Sun, 17 October 2021	5	6754	Mon, 18 October 2021 00:33 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	6140	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	7171	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	4065	Mon, 04 October 2021 06:27 By: vippysharma
	SQL Query- Connect By (merged) 11g By: sayan13 on Tue, 28 September 2021	3	7280	Tue, 28 September 2021 01:28 By: Michel Cadot
	Extract string between 2 text 11gr2 By: guddu_12 on Sun, 26 September 2021	6	5214	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	2979	Tue, 21 September 2021 20:12 By: EdStevens
	member and collection type oracle 12.1 By: pointers on Wed, 08 September 2021	4	11413	Sat, 11 September 2021 01:57 By: pointers
	Slab Level query (merged) Oracle 11 By: annu-agi on Mon, 06 September 2021	6	10908	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	7279	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	7794	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	5892	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	17694	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	21553	Mon, 30 August 2021 16:24 By: eleny
	Fire triggers on a nested_table By: ryouga82 on Fri, 27 August 2021	2	10681	Sun, 29 August 2021 11:33 By: Solomon Yakobson