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	21311	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	260593	Tue, 06 November 2018 14:17 By: Solomon Yakobson
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	1845	Thu, 22 July 2021 14:13 By: Michel Cadot
Statement Level trigger - After Insert/Update 11g By: revathitirun on Wed, 07 July 2021	4	14299	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	6967	Mon, 19 July 2021 02:24 By: Michel Cadot
get the record where the amount columns are same in 2 tables 11.2 By: mist598 on Sun, 18 July 2021	3	5971	Sun, 18 July 2021 07:27 By: EdStevens
Unable to get the PL/SQL block to work Oracle 12c, O/S: Windows 10 pro By: buggleboy007 on Fri, 16 July 2021	3	6934	Sat, 17 July 2021 12:29 By: buggleboy007
Issues with my Associative Array inside a Package spec Oracle 12c, O/S: Windows 10 pro By: buggleboy007 on Thu, 15 July 2021	3	7456	Sat, 17 July 2021 12:26 By: buggleboy007
CASE in where Clause (4 merged) SQL By: Sekhar6617 on Fri, 16 July 2021	5	8930	Sat, 17 July 2021 10:50 By: Sekhar6617
How to convert multi_byte to single_byte character Oracle 11g By: Andrey_R on Thu, 10 June 2021	7	6713	Thu, 15 July 2021 05:22 By: Andrey_R
Issues with my Associative Array Oracle 12c, O/S: Windows 10 pro By: buggleboy007 on Fri, 09 July 2021	4	10944	Sat, 10 July 2021 14:58 By: buggleboy007
Getting PLS: 00306 wrong number or types of arguments in call to 11.2.0.4 By: kamaluv234 on Wed, 30 June 2021	3	4040	Thu, 01 July 2021 00:25 By: kamaluv234
two different counts in select By: Sekhar6617 on Mon, 28 June 2021	11	5234	Tue, 29 June 2021 06:33 By: Sekhar6617
Listing table names,noofrows,noofcolumns primarkeyscol in a schema oracle 12c By: sekharsomu on Mon, 21 June 2021	5	9807	Mon, 21 June 2021 21:55 By: sekharsomu
Automate repartitions 11.2.0.3 By: Amine on Fri, 11 June 2021	1	8601	Mon, 21 June 2021 17:42 By: Amine
Help improve SQL Query 12c Linux By: deepa_balu on Tue, 15 June 2021	1	8214	Tue, 15 June 2021 14:05 By: Michel Cadot
ANSI vs Oracle Join Syntax By: dancko on Sat, 12 June 2021	7	8896	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	8961	Mon, 14 June 2021 08:29 By: wtolentino
Data masking in oracle Oracle By: bkbora on Fri, 11 June 2021	4	5465	Fri, 11 June 2021 21:59 By: bkbora
Data Extraction Oracle 12C By: ssharmila on Fri, 11 June 2021	1	3901	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	2378	Thu, 10 June 2021 12:17 By: Solomon Yakobson
Compare rows 11.2.0.3 By: Amine on Tue, 06 October 2015	5	4260	Tue, 08 June 2021 09:39 By: Michel Cadot
View creation 12c and 11g By: BunnyWorld123 on Tue, 08 June 2021	1	4247	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	5546	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	21921	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	12702	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	11861	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	6199	Tue, 18 May 2021 04:13 By: Buchas
Timezone Europe/Paris 10GR1 HPUX By: davy7887 on Fri, 07 May 2021	5	11424	Sun, 16 May 2021 14:30 By: EdStevens
Optimization of SQL 12.2 By: swasora on Sun, 09 May 2021	2	9943	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	6774	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	9107	Mon, 03 May 2021 07:23 By: Sekhar6617
sql regex_instr oracle 11g By: CindyC on Thu, 29 April 2021	11	10811	Fri, 30 April 2021 16:38 By: CindyC
substring compare and update oracle 11g By: CindyC on Wed, 28 April 2021	0	3939	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	2768	Wed, 28 April 2021 15:03 By: evoradba
ORA-00979 By: a_naq on Wed, 28 April 2021	5	3031	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	5646	Tue, 27 April 2021 10:14 By: desmond30
grouping logic oracle 11g By: yashi7777 on Sat, 24 April 2021	6	6953	Mon, 26 April 2021 20:01 By: yashi7777
Listagg over Listagg Oracle 12g By: abhayman on Sat, 24 April 2021	2	3363	Sat, 24 April 2021 03:03 By: abhayman
upper case in create table By: jchiu183 on Thu, 19 January 2006	6	9589	Sun, 18 April 2021 05:00 By: Michel Cadot