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.

		Improve Performance of Insert and Update on same table By: Shre on Mon, 19 October 2020 07:35
		Re: Improve Performance of Insert and Update on same table By: BlackSwan on Mon, 19 October 2020 08:31
		Re: Improve Performance of Insert and Update on same table By: EdStevens on Mon, 19 October 2020 09:41
		Re: Improve Performance of Insert and Update on same table By: John Watson on Tue, 20 October 2020 07:47
		Re: Improve Performance of Insert and Update on same table By: Shre on Fri, 30 October 2020 10:51

		What is the proper termination for a stored procedure created from C# code? By: Darth Waiter on Wed, 28 October 2020 11:01
		Re: What is the proper termination for a stored procedure created from C# c... By: Michel Cadot on Wed, 28 October 2020 12:05
		Re: What is the proper termination for a stored procedure created from C# c... By: Darth Waiter on Wed, 28 October 2020 14:06
		Re: What is the proper termination for a stored procedure created from C# c... By: Michel Cadot on Wed, 28 October 2020 14:22

		A query that works in SquirrelSLQL fails in C# By: Darth Waiter on Tue, 27 October 2020 15:45
		Re: A query that works in SquirrelSLQL fails in C# By: flyboy on Tue, 27 October 2020 22:00
		Re: A query that works in SquirrelSLQL fails in C# By: Michel Cadot on Wed, 28 October 2020 01:05
		Re: A query that works in SquirrelSLQL fails in C# By: EdStevens on Wed, 28 October 2020 07:59
		Re: A query that works in SquirrelSLQL fails in C# By: Darth Waiter on Wed, 28 October 2020 08:13

		ORA-1403 when trying to select after Insert By: pjizquierdo on Tue, 27 October 2020 18:58
		Re: ORA-1403 when trying to select after Insert By: BlackSwan on Tue, 27 October 2020 19:12
		Re: ORA-1403 when trying to select after Insert By: pjizquierdo on Wed, 28 October 2020 07:54
		Re: ORA-1403 when trying to select after Insert By: flyboy on Tue, 27 October 2020 20:56
		Re: ORA-1403 when trying to select after Insert By: BlackSwan on Tue, 27 October 2020 21:10

		SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Mon, 26 October 2020 16:22
		Re: SQL to retrieve lines based on a static value By: BlackSwan on Mon, 26 October 2020 16:42
		Re: SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Tue, 27 October 2020 00:38
		Re: SQL to retrieve lines based on a static value By: John Watson on Tue, 27 October 2020 01:44
		Re: SQL to retrieve lines based on a static value By: Michel Cadot on Tue, 27 October 2020 01:47
		Re: SQL to retrieve lines based on a static value By: Michel Cadot on Tue, 27 October 2020 02:46
		Re: SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Tue, 27 October 2020 05:38
		Re: SQL to retrieve lines based on a static value By: Michel Cadot on Tue, 27 October 2020 06:37
		Re: SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Tue, 27 October 2020 11:14
		Re: SQL to retrieve lines based on a static value By: Michel Cadot on Tue, 27 October 2020 11:17
		Re: SQL to retrieve lines based on a static value By: Solomon Yakobson on Tue, 27 October 2020 18:43
		Re: SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Tue, 27 October 2020 03:57
		Re: SQL to retrieve lines based on a static value By: Michel Cadot on Tue, 27 October 2020 05:01

		temp table not returning data in WITH By: radrodeo9 on Thu, 22 October 2020 21:04
		Re: temp table not returning data in WITH By: John Watson on Fri, 23 October 2020 03:28
		Re: temp table not returning data in WITH By: radrodeo9 on Fri, 23 October 2020 05:06
		Re: temp table not returning data in WITH By: John Watson on Fri, 23 October 2020 05:17
		Re: temp table not returning data in WITH By: Alien on Fri, 23 October 2020 13:48
		Re: temp table not returning data in WITH By: radrodeo9 on Fri, 23 October 2020 15:22
		Re: temp table not returning data in WITH By: Alien on Fri, 23 October 2020 15:32
		Re: temp table not returning data in WITH By: Alien on Fri, 23 October 2020 15:37
		Re: temp table not returning data in WITH By: radrodeo9 on Fri, 23 October 2020 16:01
		Re: temp table not returning data in WITH By: flyboy on Sat, 24 October 2020 23:37
		Re: temp table not returning data in WITH By: radrodeo9 on Sun, 25 October 2020 10:35
		Re: temp table not returning data in WITH By: flyboy on Sun, 25 October 2020 22:29

		Get Distinct Data By: james94539 on Sun, 25 October 2020 11:06
		Re: Get Distinct Data By: BlackSwan on Sun, 25 October 2020 11:43
		Re: Get Distinct Data By: james94539 on Sun, 25 October 2020 12:14
		Re: Get Distinct Data By: Michel Cadot on Sun, 25 October 2020 12:51
		Re: Get Distinct Data By: Michel Cadot on Sun, 25 October 2020 11:58

		Split Partition with Online / Update global indexes clause By: azeem87 on Fri, 09 October 2020 10:51
		Re: Split Partition with Online / Update global indexes clause By: John Watson on Fri, 09 October 2020 11:37
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Fri, 09 October 2020 12:23
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Fri, 09 October 2020 11:55
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 15 October 2020 12:41
		Re: Split Partition with Online / Update global indexes clause By: BlackSwan on Thu, 15 October 2020 13:01
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Thu, 15 October 2020 13:08
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 15 October 2020 13:37
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 15 October 2020 14:51
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Thu, 15 October 2020 14:53
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 15 October 2020 15:07
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Thu, 15 October 2020 15:11
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 15 October 2020 15:44
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Mon, 19 October 2020 15:53
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Tue, 20 October 2020 00:25
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 22 October 2020 09:53
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Thu, 22 October 2020 11:11
		Re: Split Partition with Online / Update global indexes clause By: azeem87 on Thu, 22 October 2020 12:53
		Re: Split Partition with Online / Update global indexes clause By: Michel Cadot on Thu, 22 October 2020 13:31
		<more>

		To_char date with and without format By: OraFerro on Thu, 22 October 2020 00:45
		Re: To_char date with and without format By: Michel Cadot on Thu, 22 October 2020 01:22
		Re: To_char date with and without format By: Solomon Yakobson on Thu, 22 October 2020 06:35

		Tree order, Sum of valid values By: vasudevaviswa on Tue, 20 October 2020 07:40
		Re: Tree order, Sum of valid values By: BlackSwan on Tue, 20 October 2020 07:44
		Re: Tree order, Sum of valid values By: vasudevaviswa on Tue, 20 October 2020 12:39

		How to generate a spool file without an extension name (.lst,.txt etc...) By: senaubi_me on Sat, 02 February 2008 05:47
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: Frank on Sat, 02 February 2008 07:22
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: senaubi_me on Sun, 03 February 2008 22:10
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: Littlefoot on Sun, 03 February 2008 23:25
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: chikurde@gmail.com on Fri, 16 October 2020 03:17
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: Michel Cadot on Fri, 16 October 2020 04:28
		Re: How to generate a spool file without an extension name (.lst,.txt etc..... By: EdStevens on Fri, 16 October 2020 08:15

		Pivot using SQL in Oracle By: calredd@yahoo.com on Thu, 15 October 2020 10:03
		Re: Pivot using SQL in Oracle By: Michel Cadot on Thu, 15 October 2020 10:23

		ORA-06502 By: anncao on Tue, 13 October 2020 14:48
		Re: ORA-06502 By: Solomon Yakobson on Tue, 13 October 2020 17:29
		Re: ORA-06502 By: anncao on Tue, 13 October 2020 18:00
		Re: ORA-06502 By: Solomon Yakobson on Tue, 13 October 2020 18:51

		converting Unix Time format to readable format By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 09:22
		Re: converting Unix Time format to readable format By: BlackSwan on Sun, 11 October 2020 09:27
		Re: converting Unix Time format to readable format By: Michel Cadot on Sun, 11 October 2020 09:52
		Re: converting Unix Time format to readable format By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 14:50
		Re: converting Unix Time format to readable format By: Michel Cadot on Sun, 11 October 2020 14:56
		Re: converting Unix Time format to readable format By: Solomon Yakobson on Sun, 11 October 2020 15:28
		Re: converting Unix Time format to readable format By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 17:27
		Re: converting Unix Time format to readable format By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 17:37
		Re: converting Unix Time format to readable format By: Michel Cadot on Mon, 12 October 2020 00:13
		Re: converting Unix Time format to readable format By: Solomon Yakobson on Mon, 12 October 2020 06:09

		Matrix Report Out put By: hissam78 on Thu, 08 October 2020 02:15
		Re: Matrix Report Out put By: John Watson on Thu, 08 October 2020 02:29
		Re: Matrix Report Out put By: hissam78 on Thu, 08 October 2020 02:33
		Re: Matrix Report Out put By: Michel Cadot on Thu, 08 October 2020 03:49
		Re: Matrix Report Out put By: Solomon Yakobson on Thu, 08 October 2020 05:40
		Re: Matrix Report Out put By: hissam78 on Sun, 11 October 2020 23:41

		REgexp_substr function to extract sub string By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 00:38
		Re: REgexp_substr function to extract sub string By: Michel Cadot on Sun, 11 October 2020 03:22
		Re: REgexp_substr function to extract sub string By: talhaparvaiz@yahoo.com on Sun, 11 October 2020 14:50

		RANK issue in SQL By: aj123tx on Thu, 08 October 2020 19:40
		Re: RANK issue in SQL By: Michel Cadot on Fri, 09 October 2020 00:23
		Re: RANK issue in SQL By: Solomon Yakobson on Fri, 09 October 2020 06:18
		Re: RANK issue in SQL By: aj123tx on Sat, 10 October 2020 06:56

		Improve efficiency of script By: Dan22 on Tue, 06 October 2020 19:02
		Re: Improve efficiency of script By: Littlefoot on Wed, 07 October 2020 00:16
		Re: Improve efficiency of script By: Michel Cadot on Wed, 07 October 2020 00:25
		Re: Improve efficiency of script By: John Watson on Wed, 07 October 2020 01:24
		Re: Improve efficiency of script By: Dan22 on Wed, 07 October 2020 01:29
		Re: Improve efficiency of script By: Michel Cadot on Wed, 07 October 2020 01:41
		Re: Improve efficiency of script By: flyboy on Thu, 08 October 2020 20:19
		Re: Improve efficiency of script By: John Watson on Fri, 09 October 2020 03:30

		Duplicate delete condition By: ritmo2k on Wed, 07 October 2020 12:16
		Re: Duplicate delete condition By: John Watson on Thu, 08 October 2020 01:23
		Re: Duplicate delete condition By: ritmo2k on Thu, 08 October 2020 05:46
		Re: Duplicate delete condition By: John Watson on Thu, 08 October 2020 06:12
		Re: Duplicate delete condition By: ritmo2k on Thu, 08 October 2020 07:32
		Re: Duplicate delete condition By: Solomon Yakobson on Thu, 08 October 2020 06:29
		Re: Duplicate delete condition By: ritmo2k on Thu, 08 October 2020 07:46

		OBJECT TYPE Body creation ERROR By: Bilal Khan on Thu, 08 October 2020 04:15
		Re: OBJECT TYPE Body creation ERROR By: Michel Cadot on Thu, 08 October 2020 05:35
		Re: OBJECT TYPE Body creation ERROR By: Bilal Khan on Thu, 08 October 2020 05:47
		Re: OBJECT TYPE Body creation ERROR By: Michel Cadot on Thu, 08 October 2020 05:57

		Join Unique Tables By: selami on Wed, 07 October 2020 02:35
		Re: Join Unique Tables By: Michel Cadot on Wed, 07 October 2020 02:44
		Re: Join Unique Tables By: John Watson on Wed, 07 October 2020 07:36

		Loop with Dates By: Adjanti on Mon, 05 October 2020 14:00
		Re: Loop with Dates By: Michel Cadot on Mon, 05 October 2020 14:22
		Re: Loop with Dates By: Michel Cadot on Mon, 05 October 2020 15:07
		Re: Loop with Dates By: Adjanti on Tue, 06 October 2020 08:51
		Re: Loop with Dates By: Michel Cadot on Tue, 06 October 2020 10:36

		Row Generator Using MODEL Clause, # Repeats Table-Based? By: Art Metzer on Mon, 05 October 2020 16:27
		Re: Row Generator Using MODEL Clause, # Repeats Table-Based? By: Solomon Yakobson on Mon, 05 October 2020 19:21
		Re: Row Generator Using MODEL Clause, # Repeats Table-Based? By: Art Metzer on Tue, 06 October 2020 09:39

		Test Oracle SQL By: misterbean on Tue, 06 October 2020 01:28
		Re: Test Oracle SQL By: John Watson on Tue, 06 October 2020 01:34
		Re: Test Oracle SQL By: Michel Cadot on Tue, 06 October 2020 01:35

		extract string and compare By: desmond30 on Mon, 05 October 2020 10:48
		Re: extract string and compare By: John Watson on Mon, 05 October 2020 11:29
		Re: extract string and compare By: desmond30 on Mon, 05 October 2020 15:24
		Re: extract string and compare By: Michel Cadot on Mon, 05 October 2020 11:48

		Pass cursor to Procedure By: ora9a on Sun, 04 October 2020 14:19
		Re: Pass cursor to Procedure By: Michel Cadot on Sun, 04 October 2020 14:52
		Re: Pass cursor to Procedure By: ora9a on Sun, 04 October 2020 15:02
		Re: Pass cursor to Procedure By: Michel Cadot on Mon, 05 October 2020 00:39
		Re: Pass cursor to Procedure By: ora9a on Mon, 05 October 2020 04:37
		Re: Pass cursor to Procedure By: Michel Cadot on Mon, 05 October 2020 05:06

		Group pivot column By: OraFerro on Sun, 04 October 2020 05:00
		Re: Group pivot column By: Michel Cadot on Sun, 04 October 2020 05:54
		Re: Group pivot column By: Solomon Yakobson on Sun, 04 October 2020 06:25
		Re: Group pivot column By: Solomon Yakobson on Sun, 04 October 2020 06:37
		Re: Group pivot column By: Solomon Yakobson on Sun, 04 October 2020 07:02
		Re: Group pivot column By: OraFerro on Sun, 04 October 2020 07:08
		Re: Group pivot column By: Michel Cadot on Sun, 04 October 2020 07:36
		Re: Group pivot column By: OraFerro on Sun, 04 October 2020 08:08
		Re: Group pivot column By: Michel Cadot on Sun, 04 October 2020 11:10
		Re: Group pivot column By: Michel Cadot on Sun, 04 October 2020 11:13
		Re: Group pivot column By: OraFerro on Mon, 05 October 2020 01:13
		Re: Group pivot column By: OraFerro on Mon, 05 October 2020 01:16
		Re: Group pivot column By: Michel Cadot on Mon, 05 October 2020 01:46
		Re: Group pivot column By: Solomon Yakobson on Sun, 04 October 2020 08:13

		update column for the set of records By: mist598 on Tue, 29 September 2020 04:40
		Re: update column for the set of records By: John Watson on Tue, 29 September 2020 04:49
		Re: update column for the set of records By: mist598 on Tue, 29 September 2020 05:30
		Re: update column for the set of records By: Michel Cadot on Tue, 29 September 2020 06:03
		Re: update column for the set of records By: mist598 on Tue, 29 September 2020 06:37
		Re: update column for the set of records By: Michel Cadot on Tue, 29 September 2020 07:12

		find the next occurrence of an event based on another event By: ac24 on Sat, 26 September 2020 00:16
		Re: find the next occurrence of an event based on another event By: John Watson on Sat, 26 September 2020 01:41
		Re: find the next occurrence of an event based on another event By: Solomon Yakobson on Sat, 26 September 2020 08:52

		How to get a substring from a character on By: Mark70 on Fri, 25 September 2020 03:09
		Re: How to get a substring from a character on By: John Watson on Fri, 25 September 2020 03:37
		Re: How to get a substring from a character on By: Mark70 on Fri, 25 September 2020 03:45
		Re: How to get a substring from a character on By: John Watson on Fri, 25 September 2020 03:47
		Re: How to get a substring from a character on By: Solomon Yakobson on Fri, 25 September 2020 10:44

		Can't connect with new user created By: Mark70 on Tue, 30 June 2020 03:06
		Re: Can't connect with new user created By: Michel Cadot on Tue, 30 June 2020 03:11
		Re: Can't connect with new user created By: Mark70 on Tue, 30 June 2020 03:15
		Re: Can't connect with new user created By: John Watson on Tue, 30 June 2020 04:32
		Re: Can't connect with new user created By: EdStevens on Tue, 30 June 2020 07:46
		Re: Can't connect with new user created By: Mark70 on Fri, 25 September 2020 03:44
		Re: Can't connect with new user created By: John Watson on Fri, 25 September 2020 03:45

		Date format with UTC By: Mark70 on Thu, 18 June 2020 03:35
		Re: Date format with UTC By: John Watson on Thu, 18 June 2020 04:00
		Re: Date format with UTC By: EdStevens on Thu, 18 June 2020 06:45
		Re: Date format with UTC By: Bill B on Mon, 22 June 2020 07:18
		Re: Date format with UTC By: Mark70 on Fri, 25 September 2020 03:44

		How to use table functions By: Mark70 on Wed, 03 June 2020 10:06
		Re: How to use table functions By: BlackSwan on Wed, 03 June 2020 10:28
		Re: How to use table functions By: Michel Cadot on Wed, 03 June 2020 10:58
		Re: How to use table functions By: EdStevens on Thu, 04 June 2020 09:30
		Re: How to use table functions By: Mark70 on Fri, 25 September 2020 03:43

		How to add SOAP elements to XML By: Mark70 on Mon, 01 June 2020 04:55
		Re: How to add SOAP elements to XML By: BlackSwan on Mon, 01 June 2020 06:40
		Re: How to add SOAP elements to XML By: Mark70 on Mon, 01 June 2020 07:07
		Re: How to add SOAP elements to XML By: Michel Cadot on Wed, 03 June 2020 10:48
		Re: How to add SOAP elements to XML By: Mark70 on Fri, 25 September 2020 03:43

		Finding entries missing a value and listing all used values for specific da... By: magriii on Wed, 23 September 2020 09:29
		Re: Finding entries missing a value and listing all used values for specifi... By: Michel Cadot on Wed, 23 September 2020 10:05
		Re: Finding entries missing a value and listing all used values for specifi... By: magriii on Wed, 23 September 2020 15:21
		Re: Finding entries missing a value and listing all used values for specifi... By: Littlefoot on Wed, 23 September 2020 15:35
		Re: Finding entries missing a value and listing all used values for specifi... By: Michel Cadot on Thu, 24 September 2020 00:18
		Re: Finding entries missing a value and listing all used values for specifi... By: magriii on Thu, 24 September 2020 00:52
		Re: Finding entries missing a value and listing all used values for specifi... By: EdStevens on Thu, 24 September 2020 07:52

		Query help on 5 tables. By: krajasekhar.n@gmail.com on Tue, 22 September 2020 07:42
		Re: Query help on 5 tables. By: Michel Cadot on Tue, 22 September 2020 10:39
		Re: Query help on 5 tables. By: Iffat on Tue, 22 September 2020 15:19
		Re: Query help on 5 tables. By: EdStevens on Tue, 22 September 2020 19:50
		Re: Query help on 5 tables. By: Iffat on Tue, 22 September 2020 22:33

		Date interval Blank count By: Marinus1979 on Wed, 16 September 2020 13:57
		Re: Date interval Blank count By: Michel Cadot on Wed, 16 September 2020 14:09
		Re: Date interval Blank count By: Littlefoot on Wed, 16 September 2020 14:22
		Re: Date interval Blank count By: Marinus1979 on Thu, 17 September 2020 01:43
		Re: Date interval Blank count By: Michel Cadot on Thu, 17 September 2020 01:57
		Re: Date interval Blank count By: Littlefoot on Fri, 18 September 2020 10:07

		understanding table partition By: wtolentino on Tue, 15 September 2020 20:26
		Re: understanding table partition By: Michel Cadot on Wed, 16 September 2020 00:37
		Re: understanding table partition By: wtolentino on Wed, 16 September 2020 04:28
		Re: understanding table partition By: Solomon Yakobson on Wed, 16 September 2020 04:58
		Re: understanding table partition By: wtolentino on Wed, 16 September 2020 06:47
		Re: understanding table partition By: John Watson on Wed, 16 September 2020 06:58
		Re: understanding table partition By: wtolentino on Wed, 16 September 2020 10:24
		Re: understanding table partition By: Michel Cadot on Wed, 16 September 2020 10:36
		Re: understanding table partition By: wtolentino on Wed, 16 September 2020 14:50
		Re: understanding table partition By: Michel Cadot on Thu, 17 September 2020 00:28

		Invisible double quotes By: pstanand on Fri, 11 September 2020 17:03
		Re: Invisible double quotes By: BlackSwan on Fri, 11 September 2020 20:31
		Re: Invisible double quotes By: pstanand on Sun, 13 September 2020 10:42
		Re: Invisible double quotes By: Michel Cadot on Sun, 13 September 2020 12:36
		Re: Invisible double quotes By: pstanand on Wed, 16 September 2020 12:43
		Re: Invisible double quotes By: Michel Cadot on Wed, 16 September 2020 14:08
		Re: Invisible double quotes By: Michel Cadot on Sat, 12 September 2020 00:35
		Re: Invisible double quotes By: Solomon Yakobson on Sat, 12 September 2020 05:57
		Re: Invisible double quotes By: EdStevens on Sat, 12 September 2020 07:48

		How to retrieve data only those which are in decimals By: lacchhii on Tue, 15 September 2020 01:23
		Re: How to retrieve data only those which are in decimals By: Michel Cadot on Tue, 15 September 2020 02:27
		Re: How to retrieve data only those which are in decimals By: lacchhii on Tue, 15 September 2020 04:33
		Re: How to retrieve data only those which are in decimals By: Michel Cadot on Tue, 15 September 2020 05:03
		Re: How to retrieve data only those which are in decimals By: lacchhii on Tue, 15 September 2020 06:06

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

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 17:06:23 CDT 2024