OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL
Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

		member and collection type By: pointers on Wed, 08 September 2021 12:26
		Re: member and collection type By: Michel Cadot on Wed, 08 September 2021 12:55
		Re: member and collection type By: pointers on Wed, 08 September 2021 13:08
		Re: member and collection type By: Michel Cadot on Wed, 08 September 2021 13:38
		Re: member and collection type By: pointers on Sat, 11 September 2021 01:57

		Slab Level query (merged) By: annu-agi on Mon, 06 September 2021 06:51
		Slab Level query By: annu-agi on Mon, 06 September 2021 06:52
		Re: Slab Level query By: EdStevens on Mon, 06 September 2021 14:02
		Re: Slab Level query By: annu-agi on Mon, 06 September 2021 23:47
		Re: Slab Level query By: Michel Cadot on Tue, 07 September 2021 00:33
		Re: Slab Level query By: annu-agi on Tue, 07 September 2021 03:00
		Re: Slab Level query (merged) By: Michel Cadot on Mon, 06 September 2021 07:37

		Function Finding multiple occurrences of a string By: Unclefool on Mon, 06 September 2021 14:06
		Re: Function Finding multiple occurrences of a string By: Michel Cadot on Mon, 06 September 2021 14:51
		Re: Function Finding multiple occurrences of a string By: Unclefool on Mon, 06 September 2021 15:24
		Re: Function Finding multiple occurrences of a string By: Solomon Yakobson on Mon, 06 September 2021 16:52
		Re: Function Finding multiple occurrences of a string By: Unclefool on Mon, 06 September 2021 21:23

		query to display employee whose code is 03 is not inserted By: glmjoy on Sat, 04 September 2021 02:38
		Re: query to display employee whose code is 03 is not inserted By: John Watson on Sat, 04 September 2021 02:50
		Re: query to display employee whose code is 03 is not inserted By: glmjoy on Sat, 04 September 2021 03:05
		Re: query to display employee whose code is 03 is not inserted By: glmjoy on Sat, 04 September 2021 08:17
		Re: query to display employee whose code is 03 is not inserted By: Michel Cadot on Sat, 04 September 2021 09:33
		Re: query to display employee whose code is 03 is not inserted By: EdStevens on Sat, 04 September 2021 09:45
		Re: query to display employee whose code is 03 is not inserted By: glmjoy on Sat, 04 September 2021 13:46

		Write an SQL query to report the students (student_id, student_name) being ... By: vritik on Fri, 03 September 2021 08:50
		Re: Write an SQL query to report the students (student_id, student_name) be... By: Michel Cadot on Fri, 03 September 2021 11:54

		Error ocurred calling a Web Service using UTL_HTTP By: gusmenp on Thu, 27 June 2013 18:40
		Re: Error ocurred calling a Web Service using UTL_HTTP By: BlackSwan on Thu, 27 June 2013 19:11
		Re: Error ocurred calling a Web Service using UTL_HTTP By: gusmenp on Thu, 27 June 2013 22:55
		Re: Error ocurred calling a Web Service using UTL_HTTP By: chris_a on Wed, 09 October 2013 09:49
		Re: Error ocurred calling a Web Service using UTL_HTTP By: Lalit Kumar B on Wed, 09 October 2013 12:09
		Re: Error ocurred calling a Web Service using UTL_HTTP By: gusmenp on Wed, 12 March 2014 10:48
		Re: Error ocurred calling a Web Service using UTL_HTTP By: mohsin0012 on Tue, 31 August 2021 07:37

		Duplicating Excel "RATE" function in Oracle By: Primordial on Wed, 18 February 2015 02:39
		Re: Duplicating Excel "RATE" function in Oracle By: Lalit Kumar B on Wed, 18 February 2015 05:09
		Re: Duplicating Excel "RATE" function in Oracle By: Primordial on Wed, 18 February 2015 06:43
		Re: Duplicating Excel "RATE" function in Oracle By: PHILLIPM.33 on Wed, 16 May 2018 05:02
		Re: Duplicating Excel "RATE" function in Oracle By: Barbara Boehmer on Sun, 20 May 2018 04:49
		Re: Duplicating Excel "RATE" function in Oracle By: PHILLIPM.33 on Mon, 21 May 2018 10:52
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Thu, 13 December 2018 03:51
		Re: Duplicating Excel "RATE" function in Oracle By: Solomon Yakobson on Thu, 13 December 2018 05:53
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Thu, 13 December 2018 07:07
		Re: Duplicating Excel "RATE" function in Oracle By: cookiemonster on Thu, 13 December 2018 09:14
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Sun, 16 December 2018 01:16
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Sun, 16 December 2018 03:07
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Sun, 16 December 2018 03:10
		Re: Duplicating Excel "RATE" function in Oracle By: Michel Cadot on Sun, 16 December 2018 04:44
		Re: Duplicating Excel "RATE" function in Oracle By: a_nawas_khan on Mon, 17 December 2018 03:24
		Re: Duplicating Excel "RATE" function in Oracle By: Barbara Boehmer on Mon, 17 December 2018 15:35
		<more>

		Fire triggers on a nested_table By: ryouga82 on Fri, 27 August 2021 04:30
		Re: Fire triggers on a nested_table By: Michel Cadot on Fri, 27 August 2021 10:30
		Re: Fire triggers on a nested_table By: Solomon Yakobson on Sun, 29 August 2021 11:33

		Oracle Invalid hint By: Unclefool on Fri, 27 August 2021 17:14
		Re: Oracle Invalid hint By: John Watson on Sat, 28 August 2021 01:27

		Generate Unique Grouping ID By: Manoj.Gupta.91 on Thu, 26 August 2021 04:25
		Re: Generate Unique Grouping ID By: Michel Cadot on Thu, 26 August 2021 05:09
		Re: Generate Unique Grouping ID By: Manoj.Gupta.91 on Thu, 26 August 2021 05:15
		Re: Generate Unique Grouping ID By: _jum on Fri, 27 August 2021 01:13

		About REF datatype By: Michel Cadot on Fri, 20 August 2021 11:43
		Re: About REF datatype By: Solomon Yakobson on Fri, 20 August 2021 16:56
		Re: About REF datatype By: Michel Cadot on Sat, 21 August 2021 01:04
		Re: About REF datatype By: Solomon Yakobson on Sun, 22 August 2021 11:04
		Re: About REF datatype By: Michel Cadot on Sun, 22 August 2021 12:08
		Re: About REF datatype By: Solomon Yakobson on Sun, 22 August 2021 13:28
		Re: About REF datatype By: Michel Cadot on Sun, 22 August 2021 14:06
		Re: About REF datatype By: Solomon Yakobson on Sun, 22 August 2021 14:56
		Re: About REF datatype By: Solomon Yakobson on Sun, 22 August 2021 15:14
		Re: About REF datatype By: Michel Cadot on Sun, 22 August 2021 15:22
		Re: About REF datatype By: Solomon Yakobson on Sun, 22 August 2021 15:46
		Re: About REF datatype By: Michel Cadot on Mon, 23 August 2021 01:15

		Oracle INSERT, SELECT, NOT EXISTS primary key By: Unclefool on Sat, 21 August 2021 09:08
		Re: Oracle INSERT, SELECT, NOT EXISTS primary key By: John Watson on Sat, 21 August 2021 09:44
		Re: Oracle INSERT, SELECT, NOT EXISTS primary key By: Unclefool on Sat, 21 August 2021 12:56
		Re: Oracle INSERT, SELECT, NOT EXISTS primary key By: Andrey_R on Sun, 22 August 2021 14:21

		Oracle cte multiple rows (3 merged) By: Unclefool on Thu, 19 August 2021 07:49
		Oracle cte multiple rows By: Unclefool on Thu, 19 August 2021 07:50
		Oracle cte multiple rows By: Unclefool on Thu, 19 August 2021 07:51

		Oracle procedure passing NULL in DATE parameters By: Unclefool on Wed, 18 August 2021 11:14
		Re: Oracle procedure passing NULL in DATE parameters By: Solomon Yakobson on Wed, 18 August 2021 11:56
		Re: Oracle procedure passing NULL in DATE parameters By: Unclefool on Wed, 18 August 2021 13:18

		Creating time rows that doesn't cross midnight By: Unclefool on Tue, 17 August 2021 02:29
		Re: Creating time rows that doesn't cross midnight By: Solomon Yakobson on Tue, 17 August 2021 04:53
		Creating time rows that doesn't cross midnight By: Unclefool on Tue, 17 August 2021 09:13
		Re: Creating time rows that doesn't cross midnight By: Solomon Yakobson on Tue, 17 August 2021 17:11
		Re: Creating time rows that doesn't cross midnight By: Unclefool on Wed, 18 August 2021 08:36

		How to execute dynamically the permission grant using AWS RDS custom proc... By: kesavansundaram on Tue, 17 August 2021 16:10
		How to execute dynamically the permission grant using AWS RDS custom proced... By: kesavansundaram on Tue, 17 August 2021 16:10
		Re: How to execute dynamically the permission grant using AWS RDS custom pr... By: Michel Cadot on Wed, 18 August 2021 00:05

		SYSAUX IMPACT ON PERFORMANCE By: vippysharma on Mon, 16 August 2021 22:44
		Re: SYSAUX IMPACT ON PERFORMANCE By: Michel Cadot on Tue, 17 August 2021 00:17

		Creating rows every 5 minutes without overlap By: Unclefool on Mon, 16 August 2021 11:12
		Re: Creating rows every 5 minutes without overlap By: Solomon Yakobson on Mon, 16 August 2021 19:11
		Re: Creating rows every 5 minutes without overlap By: Unclefool on Mon, 16 August 2021 19:53

		Table type collection in SELECT By: sinpeak on Thu, 05 August 2021 03:46
		Re: Table type collection in SELECT By: _jum on Wed, 11 August 2021 00:58
		Re: Table type collection in SELECT By: sinpeak on Wed, 11 August 2021 01:20

		BMP not correctly formated with UTF8 Characterset By: Usman Tabassum on Thu, 05 August 2021 05:22
		Re: BMP not correctly formated with UTF8 Characterset By: Michel Cadot on Thu, 05 August 2021 09:42
		Re: BMP not correctly formated with UTF8 Characterset By: Usman Tabassum on Fri, 06 August 2021 00:57
		Re: BMP not correctly formated with UTF8 Characterset By: Michel Cadot on Fri, 06 August 2021 04:16

		Question about databses By: itmasterw on Wed, 04 August 2021 08:38
		Re: Question about databses By: Michel Cadot on Wed, 04 August 2021 10:26
		Re: Question about databses By: itmasterw on Wed, 04 August 2021 10:34
		Re: Question about databses By: EdStevens on Wed, 04 August 2021 10:44
		Re: Question about databses By: itmasterw on Wed, 04 August 2021 11:04

		QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 03:04
		Re: QUERY TO DISPLAY EDUCATION By: Michel Cadot on Wed, 28 July 2021 03:38
		Re: QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 04:08
		Re: QUERY TO DISPLAY EDUCATION By: Michel Cadot on Wed, 28 July 2021 05:33
		Re: QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 06:03
		Re: QUERY TO DISPLAY EDUCATION By: Michel Cadot on Wed, 28 July 2021 06:06
		Re: QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 06:38
		Re: QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 06:39
		Re: QUERY TO DISPLAY EDUCATION By: Solomon Yakobson on Wed, 28 July 2021 07:03
		Re: QUERY TO DISPLAY EDUCATION By: glmjoy on Wed, 28 July 2021 08:03
		Re: QUERY TO DISPLAY EDUCATION By: EdStevens on Wed, 28 July 2021 09:14

		Execution Plan of query By: saipradyumn on Tue, 27 July 2021 03:32
		Re: Execution Plan of query By: John Watson on Tue, 27 July 2021 03:47
		Re: Execution Plan of query By: saipradyumn on Tue, 27 July 2021 07:03

		Prime Generation Logic using in single Query By: saipradyumn on Thu, 22 July 2021 11:36
		Re: Prime Generation Logic using in single Query By: Michel Cadot on Thu, 22 July 2021 11:52
		Re: Prime Generation Logic using in single Query By: saipradyumn on Thu, 22 July 2021 12:38
		Re: Prime Generation Logic using in single Query By: Michel Cadot on Thu, 22 July 2021 14:13

		Statement Level trigger - After Insert/Update By: revathitirun on Wed, 07 July 2021 05:21
		Re: Statement Level trigger - After Insert/Update By: Solomon Yakobson on Wed, 07 July 2021 06:05
		Re: Statement Level trigger - After Insert/Update By: EdStevens on Wed, 07 July 2021 09:18
		Re: Statement Level trigger - After Insert/Update By: revathitirun on Thu, 22 July 2021 11:25
		Re: Statement Level trigger - After Insert/Update By: Michel Cadot on Thu, 22 July 2021 11:42

		How to stop swapping in EXCHANGE PARTITION By: gopalMisra on Fri, 16 July 2021 12:36
		Re: How to stop swapping in EXCHANGE PARTITION By: Michel Cadot on Fri, 16 July 2021 13:20
		Re: How to stop swapping in EXCHANGE PARTITION By: Solomon Yakobson on Sat, 17 July 2021 06:24
		Re: How to stop swapping in EXCHANGE PARTITION By: John Watson on Sun, 18 July 2021 01:07
		Re: How to stop swapping in EXCHANGE PARTITION By: Michel Cadot on Sun, 18 July 2021 02:07
		Re: How to stop swapping in EXCHANGE PARTITION By: gopalMisra on Mon, 19 July 2021 01:20
		Re: How to stop swapping in EXCHANGE PARTITION By: Michel Cadot on Mon, 19 July 2021 02:15
		Re: How to stop swapping in EXCHANGE PARTITION By: Michel Cadot on Mon, 19 July 2021 02:24

		get the record where the amount columns are same in 2 tables By: mist598 on Sun, 18 July 2021 05:27
		Re: get the record where the amount columns are same in 2 tables By: Michel Cadot on Sun, 18 July 2021 06:06
		Re: get the record where the amount columns are same in 2 tables By: mist598 on Sun, 18 July 2021 06:12
		Re: get the record where the amount columns are same in 2 tables By: EdStevens on Sun, 18 July 2021 07:27

		Unable to get the PL/SQL block to work By: buggleboy007 on Fri, 16 July 2021 11:50
		Re: Unable to get the PL/SQL block to work By: buggleboy007 on Fri, 16 July 2021 15:35
		Re: Unable to get the PL/SQL block to work By: Michel Cadot on Sat, 17 July 2021 00:11
		Re: Unable to get the PL/SQL block to work By: buggleboy007 on Sat, 17 July 2021 12:29

		Issues with my Associative Array inside a Package spec By: buggleboy007 on Thu, 15 July 2021 09:56
		Re: Issues with my Associative Array inside a Package spec By: buggleboy007 on Thu, 15 July 2021 10:13
		Re: Issues with my Associative Array inside a Package spec By: Michel Cadot on Sat, 17 July 2021 00:12
		Re: Issues with my Associative Array inside a Package spec By: buggleboy007 on Sat, 17 July 2021 12:26

		CASE in where Clause (4 merged) By: Sekhar6617 on Fri, 16 July 2021 08:27
		CASE in where Clause By: Sekhar6617 on Fri, 16 July 2021 08:27
		CASE in where Clause By: Sekhar6617 on Fri, 16 July 2021 08:28
		CASE in where Clause By: Sekhar6617 on Fri, 16 July 2021 08:28
		Re: CASE in where Clause By: Michel Cadot on Fri, 16 July 2021 10:42
		Re: CASE in where Clause By: Sekhar6617 on Sat, 17 July 2021 10:50

		How to convert multi_byte to single_byte character By: Andrey_R on Thu, 10 June 2021 06:56
		Re: How to convert multi_byte to single_byte character By: Andrey_R on Thu, 10 June 2021 09:57
		Re: How to convert multi_byte to single_byte character By: Michel Cadot on Thu, 10 June 2021 10:23
		Re: How to convert multi_byte to single_byte character By: Andrey_R on Thu, 10 June 2021 11:56
		Re: How to convert multi_byte to single_byte character By: Michel Cadot on Thu, 10 June 2021 12:11
		Re: How to convert multi_byte to single_byte character By: Andrey_R on Sun, 13 June 2021 09:53
		Re: How to convert multi_byte to single_byte character By: Michel Cadot on Sun, 13 June 2021 10:53
		Re: How to convert multi_byte to single_byte character By: Andrey_R on Thu, 15 July 2021 05:22

		Issues with my Associative Array By: buggleboy007 on Fri, 09 July 2021 21:35
		Re: Issues with my Associative Array By: Solomon Yakobson on Sat, 10 July 2021 09:23
		Re: Issues with my Associative Array By: buggleboy007 on Sat, 10 July 2021 12:05
		Re: Issues with my Associative Array By: Michel Cadot on Sat, 10 July 2021 12:34
		Re: Issues with my Associative Array By: buggleboy007 on Sat, 10 July 2021 14:58

		Getting PLS: 00306 wrong number or types of arguments in call to By: kamaluv234 on Wed, 30 June 2021 23:10
		Re: Getting PLS: 00306 wrong number or types of arguments in call to By: Michel Cadot on Thu, 01 July 2021 00:15
		Re: Getting PLS: 00306 wrong number or types of arguments in call to By: kamaluv234 on Thu, 01 July 2021 00:25
		Re: Getting PLS: 00306 wrong number or types of arguments in call to By: Littlefoot on Thu, 01 July 2021 00:18

		two different counts in select By: Sekhar6617 on Mon, 28 June 2021 12:19
		Re: two different counts in select By: Michel Cadot on Mon, 28 June 2021 12:58
		Re: two different counts in select By: Sekhar6617 on Mon, 28 June 2021 20:45
		Re: two different counts in select By: Michel Cadot on Tue, 29 June 2021 00:09
		Re: two different counts in select By: Michel Cadot on Tue, 29 June 2021 00:29
		Re: two different counts in select By: Sekhar6617 on Tue, 29 June 2021 00:57
		Re: two different counts in select By: Michel Cadot on Tue, 29 June 2021 01:48
		Re: two different counts in select By: Sekhar6617 on Tue, 29 June 2021 03:17
		Re: two different counts in select By: Michel Cadot on Tue, 29 June 2021 04:26
		Re: two different counts in select By: Sekhar6617 on Tue, 29 June 2021 05:12
		Re: two different counts in select By: Michel Cadot on Tue, 29 June 2021 05:30
		Re: two different counts in select By: Sekhar6617 on Tue, 29 June 2021 06:33

		Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: sekharsomu on Mon, 21 June 2021 15:03
		Re: Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: Solomon Yakobson on Mon, 21 June 2021 15:39
		Re: Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: Solomon Yakobson on Mon, 21 June 2021 15:45
		Re: Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: sekharsomu on Mon, 21 June 2021 21:55
		Re: Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: Michel Cadot on Mon, 21 June 2021 15:43
		Re: Listing table names,noofrows,noofcolumns primarkeyscol in a schema By: Michel Cadot on Mon, 21 June 2021 15:45

		Automate repartitions By: Amine on Fri, 11 June 2021 16:24
		Re: Automate repartitions By: Amine on Mon, 21 June 2021 17:42

		Help improve SQL Query By: deepa_balu on Tue, 15 June 2021 13:59
		Re: Help improve SQL Query By: Michel Cadot on Tue, 15 June 2021 14:05

		ANSI vs Oracle Join Syntax By: dancko on Sat, 12 June 2021 09:43
		Re: ANSI vs Oracle Join Syntax By: BlackSwan on Sat, 12 June 2021 10:05
		Re: ANSI vs Oracle Join Syntax By: John Watson on Sat, 12 June 2021 10:27
		Re: ANSI vs Oracle Join Syntax By: dancko on Sat, 12 June 2021 11:10
		Re: ANSI vs Oracle Join Syntax By: John Watson on Sun, 13 June 2021 01:24
		Re: ANSI vs Oracle Join Syntax By: Littlefoot on Sun, 13 June 2021 11:40
		Re: ANSI vs Oracle Join Syntax By: Solomon Yakobson on Sun, 13 June 2021 13:37
		Re: ANSI vs Oracle Join Syntax By: Littlefoot on Tue, 15 June 2021 12:04

		dbms_scheduler.create_job() throws error ORA-27362 By: wtolentino on Fri, 11 June 2021 15:01
		Re: dbms_scheduler.create_job() throws error ORA-27362 By: Solomon Yakobson on Fri, 11 June 2021 15:41
		Re: dbms_scheduler.create_job() throws error ORA-27362 By: wtolentino on Mon, 14 June 2021 08:29

		Data masking in oracle By: bkbora on Fri, 11 June 2021 12:14
		Re: Data masking in oracle By: John Watson on Fri, 11 June 2021 12:47
		Re: Data masking in oracle By: Michel Cadot on Fri, 11 June 2021 12:47
		Re: Data masking in oracle By: bkbora on Fri, 11 June 2021 21:59
		Re: Data masking in oracle By: Solomon Yakobson on Fri, 11 June 2021 14:51

Pages (1271): [ « ‹ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Wed Apr 24 06:41:44 CDT 2024