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
query to display employee whose code is 03 is not inserted 11g By: glmjoy on Sat, 04 September 2021	6	10480	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	7993	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	21588	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	30113	Mon, 30 August 2021 16:24 By: eleny
Fire triggers on a nested_table By: ryouga82 on Fri, 27 August 2021	2	12798	Sun, 29 August 2021 11:33 By: Solomon Yakobson
Oracle Invalid hint 19c By: Unclefool on Fri, 27 August 2021	1	13635	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	11259	Fri, 27 August 2021 01:13 By: _jum
About REF datatype 10.2 to 19 By: Michel Cadot on Fri, 20 August 2021	11	17116	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	10699	Sun, 22 August 2021 14:21 By: Andrey_R
Oracle cte multiple rows (3 merged) 19c By: Unclefool on Thu, 19 August 2021	2	9714	Thu, 19 August 2021 07:51 By: Unclefool
Oracle procedure passing NULL in DATE parameters 19c By: Unclefool on Wed, 18 August 2021	2	9959	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	8120	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	7888	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	3359	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	4375	Mon, 16 August 2021 19:53 By: Unclefool
Table type collection in SELECT Oracle 11g By: sinpeak on Thu, 05 August 2021	2	11066	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	13913	Fri, 06 August 2021 04:16 By: Michel Cadot
Question about databses By: itmasterw on Wed, 04 August 2021	4	12167	Wed, 04 August 2021 11:04 By: itmasterw
QUERY TO DISPLAY EDUCATION 11g By: glmjoy on Wed, 28 July 2021	10	16359	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	16145	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	8219	Thu, 22 July 2021 14:13 By: Michel Cadot
Statement Level trigger - After Insert/Update 11g By: revathitirun on Wed, 07 July 2021	4	19416	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	12590	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	8936	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	10223	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	10551	Sat, 17 July 2021 12:26 By: buggleboy007
CASE in where Clause (4 merged) SQL By: Sekhar6617 on Fri, 16 July 2021	5	11965	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	11553	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	15913	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	8021	Thu, 01 July 2021 00:25 By: kamaluv234
two different counts in select By: Sekhar6617 on Mon, 28 June 2021	11	10663	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	13619	Mon, 21 June 2021 21:55 By: sekharsomu
Automate repartitions 11.2.0.3 By: Amine on Fri, 11 June 2021	1	10922	Mon, 21 June 2021 17:42 By: Amine
Help improve SQL Query 12c Linux By: deepa_balu on Tue, 15 June 2021	1	11254	Tue, 15 June 2021 14:05 By: Michel Cadot
ANSI vs Oracle Join Syntax By: dancko on Sat, 12 June 2021	7	13971	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	11568	Mon, 14 June 2021 08:29 By: wtolentino
Data masking in oracle Oracle By: bkbora on Fri, 11 June 2021	4	9318	Fri, 11 June 2021 21:59 By: bkbora
CHR(n) equivalent function for double-byte characters Oracle 12.1.0.2.0 By: Andrey_R on Thu, 10 June 2021	5	5822	Thu, 10 June 2021 12:17 By: Solomon Yakobson
Compare rows 11.2.0.3 By: Amine on Tue, 06 October 2015	5	7690	Tue, 08 June 2021 09:39 By: Michel Cadot
View creation 12c and 11g By: BunnyWorld123 on Tue, 08 June 2021	1	6308	Tue, 08 June 2021 07:39 By: John Watson