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
ANSI vs Oracle Join Syntax By: dancko on Sat, 12 June 2021	7	11149	Tue, 15 June 2021 12:04 By: Littlefoot
dbms_scheduler.create_job() throws error ORA-27362 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Fri, 11 June 2021	2	10003	Mon, 14 June 2021 08:29 By: wtolentino
Data masking in oracle Oracle By: bkbora on Fri, 11 June 2021	4	7017	Fri, 11 June 2021 21:59 By: bkbora
Data Extraction Oracle 12C By: ssharmila on Fri, 11 June 2021	1	4770	Fri, 11 June 2021 10:43 By: Michel Cadot
CHR(n) equivalent function for double-byte characters Oracle 12.1.0.2.0 By: Andrey_R on Thu, 10 June 2021	5	3740	Thu, 10 June 2021 12:17 By: Solomon Yakobson
Compare rows 11.2.0.3 By: Amine on Tue, 06 October 2015	5	5680	Tue, 08 June 2021 09:39 By: Michel Cadot
View creation 12c and 11g By: BunnyWorld123 on Tue, 08 June 2021	1	5054	Tue, 08 June 2021 07:39 By: John Watson
How to spead up query that calls the save view multiple times 12 By: helixpoint on Tue, 01 June 2021	3	6866	Wed, 02 June 2021 05:55 By: Solomon Yakobson
Nested Queries with Select Statement Oracle 12 c, 12.1.0.1 By: a_naq on Mon, 10 May 2021	13	24840	Wed, 26 May 2021 10:02 By: BlackSwan
Present value calculations in Oracle 12.1.0.1 By: OraFerro on Mon, 24 May 2021	2	14125	Mon, 24 May 2021 04:34 By: John Watson
SUM of parent and child records 11.2 By: mist598 on Sun, 23 May 2021	1	12659	Mon, 24 May 2021 00:36 By: Michel Cadot
Cents corrupted on large number Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: Buchas on Tue, 18 May 2021	2	7157	Tue, 18 May 2021 04:13 By: Buchas
Timezone Europe/Paris 10GR1 HPUX By: davy7887 on Fri, 07 May 2021	5	12918	Sun, 16 May 2021 14:30 By: EdStevens
Optimization of SQL 12.2 By: swasora on Sun, 09 May 2021	2	11107	Sun, 09 May 2021 06:55 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	8260	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	10802	Mon, 03 May 2021 07:23 By: Sekhar6617
sql regex_instr oracle 11g By: CindyC on Thu, 29 April 2021	11	12975	Fri, 30 April 2021 16:38 By: CindyC
substring compare and update oracle 11g By: CindyC on Wed, 28 April 2021	0	4574	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	3579	Wed, 28 April 2021 15:03 By: evoradba
ORA-00979 By: a_naq on Wed, 28 April 2021	5	4384	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	7023	Tue, 27 April 2021 10:14 By: desmond30
grouping logic oracle 11g By: yashi7777 on Sat, 24 April 2021	6	8071	Mon, 26 April 2021 20:01 By: yashi7777
Listagg over Listagg Oracle 12g By: abhayman on Sat, 24 April 2021	2	4256	Sat, 24 April 2021 03:03 By: abhayman
upper case in create table By: jchiu183 on Thu, 19 January 2006	6	11766	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	7089	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	11496	Wed, 14 April 2021 23:16 By: Sekhar6617
ORA-00904: "SUPPID": invalid identifier oracle By: whotheunknown on Sat, 10 April 2021	5	8328	Mon, 12 April 2021 18:30 By: EdStevens
Query to Display date 11g By: glmjoy on Fri, 09 April 2021	2	9796	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	9219	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	16228	Wed, 07 April 2021 04:49 By: Udays
Oracle Sql statements R12 By: Andrescr5 on Mon, 05 April 2021	1	1957	Mon, 05 April 2021 11:41 By: EdStevens
Query PL/SQL Urgent By: Vins82 on Fri, 02 April 2021	1	5493	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	6047	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	4037	Wed, 31 March 2021 07:19 By: Heavyd
query display like aging 11g By: glmjoy on Tue, 30 March 2021	6	7823	Wed, 31 March 2021 01:15 By: glmjoy
group by common string oracle 11g By: yashi7777 on Wed, 17 March 2021	8	11685	Mon, 29 March 2021 20:49 By: yashi7777
Analytical functions By: jay_yan on Mon, 29 March 2021	4	4883	Mon, 29 March 2021 10:30 By: Michel Cadot
sort with duplicate records 12 By: mape on Sat, 27 March 2021	5	5815	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	7697	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	6630	Wed, 24 March 2021 11:49 By: Michel Cadot