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	19891	Tue, 30 June 2020 11:23 By: Michel Cadot
	sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	256210	Tue, 06 November 2018 14:17 By: Solomon Yakobson
	Nested Queries with Select Statement Oracle 12 c, 12.1.0.1 By: a_naq on Mon, 10 May 2021	7	8630	Wed, 12 May 2021 11:49 By: a_naq
ORA-24373 invalid length specified for statement (spllt) has been moved to Client Tools by the moderator.
	Optimization of SQL 12.2 By: swasora on Sun, 09 May 2021	2	8966	Sun, 09 May 2021 06:55 By: Solomon Yakobson
	Timezone Europe/Paris 10GR1 HPUX By: davy7887 on Fri, 07 May 2021	3	5932	Fri, 07 May 2021 19:35 By: Solomon Yakobson
	multiple queries and 1 output window/result Oracle SQL Developer 19.1.0.094 / Oracle Database 12.2.0.1.0 By: abenitez77 on Mon, 03 May 2021	6	5703	Mon, 03 May 2021 12:08 By: Michel Cadot
	how to get the rows of different values of single column By: Sekhar6617 on Wed, 21 April 2021	9	8134	Mon, 03 May 2021 07:23 By: Sekhar6617
	sql regex_instr oracle 11g By: CindyC on Thu, 29 April 2021	11	9478	Fri, 30 April 2021 16:38 By: CindyC
	substring compare and update oracle 11g By: CindyC on Wed, 28 April 2021	0	3252	Wed, 28 April 2021 15:33 By: CindyC
	how to change a column to a virtual Linux RDBMS 12c By: evoradba on Wed, 28 April 2021	2	2032	Wed, 28 April 2021 15:03 By: evoradba
	ORA-00979 By: a_naq on Wed, 28 April 2021	5	2158	Wed, 28 April 2021 12:23 By: Solomon Yakobson
	pipeline function call in a stored proc and loop By: desmond30 on Mon, 26 April 2021	8	4605	Tue, 27 April 2021 10:14 By: desmond30
	grouping logic oracle 11g By: yashi7777 on Sat, 24 April 2021	6	6073	Mon, 26 April 2021 20:01 By: yashi7777
	Listagg over Listagg Oracle 12g By: abhayman on Sat, 24 April 2021	2	2607	Sat, 24 April 2021 03:03 By: abhayman
	upper case in create table By: jchiu183 on Thu, 19 January 2006	6	8514	Sun, 18 April 2021 05:00 By: Michel Cadot
	Hierarchy again and again and again ! 11.2.0.3 By: Amine on Wed, 14 April 2021	3	5455	Thu, 15 April 2021 05:02 By: Michel Cadot
	how to remove html tags from the text By: Sekhar6617 on Thu, 08 April 2021	8	9520	Wed, 14 April 2021 23:16 By: Sekhar6617
	ORA-00904: "SUPPID": invalid identifier oracle By: whotheunknown on Sat, 10 April 2021	5	6389	Mon, 12 April 2021 18:30 By: EdStevens
	Query to Display date 11g By: glmjoy on Fri, 09 April 2021	2	8493	Fri, 09 April 2021 07:14 By: glmjoy
	Mark Only Selected Portion of a Column Data 12.1 By: azeem87 on Thu, 08 April 2021	4	7565	Fri, 09 April 2021 00:20 By: Michel Cadot
	Display zero if negative value. Oracle 8i, Windows Server 2003 By: kumarvk on Mon, 09 January 2012	3	12942	Wed, 07 April 2021 04:49 By: Udays
	Oracle Sql statements R12 By: Andrescr5 on Mon, 05 April 2021	1	747	Mon, 05 April 2021 11:41 By: EdStevens
	Query PL/SQL Urgent By: Vins82 on Fri, 02 April 2021	1	4072	Fri, 02 April 2021 03:56 By: Michel Cadot
	filtering for records based on select criteria oracle plsql By: padler on Wed, 31 March 2021	2	4624	Thu, 01 April 2021 09:23 By: John Watson
	Disperse credit notes between groups of invoices Oracle12c Release 12.1.0.2.0 By: Heavyd on Wed, 31 March 2021	1	2969	Wed, 31 March 2021 07:19 By: Heavyd
	query display like aging 11g By: glmjoy on Tue, 30 March 2021	6	6011	Wed, 31 March 2021 01:15 By: glmjoy
	group by common string oracle 11g By: yashi7777 on Wed, 17 March 2021	8	10265	Mon, 29 March 2021 20:49 By: yashi7777
	Analytical functions By: jay_yan on Mon, 29 March 2021	4	3374	Mon, 29 March 2021 10:30 By: Michel Cadot
	sort with duplicate records 12 By: mape on Sat, 27 March 2021	5	4345	Sun, 28 March 2021 12:01 By: mape
	12.1.0.1 Filter dates between a list of start and end dates By: OraFerro on Thu, 25 March 2021	2	6586	Sat, 27 March 2021 23:25 By: OraFerro
	how to use select field value in where clause (merged) By: Sekhar6617 on Wed, 24 March 2021	2	5407	Wed, 24 March 2021 11:49 By: Michel Cadot
	Generate SQL via SQL By: mikewazowski on Tue, 23 February 2021	32	12767	Thu, 18 March 2021 03:25 By: Michel Cadot
	Generating Installment rows 12.1.0.1 By: OraFerro on Tue, 16 March 2021	1	8245	Tue, 16 March 2021 23:28 By: OraFerro
	Beginner question. Update query with another SQL 11g By: RM33 on Sat, 13 March 2021	2	4516	Sun, 14 March 2021 06:10 By: Littlefoot
	Parsing XML multiple CDATA with & and withoutn & Oracle 12c 2 By: sss111ind on Sun, 07 March 2021	3	7366	Mon, 08 March 2021 04:17 By: Solomon Yakobson
	Need help on Tabibitosan (start of group) 11.2.0.3 By: Amine on Fri, 05 March 2021	16	9957	Sat, 06 March 2021 16:49 By: Amine
	Setting up Email service on Oracle 9i Oracle Database 9i By: rfcl on Thu, 04 March 2021	9	5766	Fri, 05 March 2021 00:54 By: Michel Cadot
	How to call/execute a visual basic script using PL / SQL oracle db v9i By: rfcl on Thu, 04 March 2021	2	5998	Fri, 05 March 2021 00:13 By: rfcl
	schema level dml trigger oracle 10g By: pradeep08 on Wed, 03 March 2021	2	4017	Thu, 04 March 2021 12:32 By: EdStevens