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
Improve Performance of Insert and Update on same table 12.1.0.2.0 By: Shre on Mon, 19 October 2020	4	5278	Fri, 30 October 2020 10:51 By: Shre
What is the proper termination for a stored procedure created from C# code? Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows By: Darth Waiter on Wed, 28 October 2020	3	4579	Wed, 28 October 2020 14:22 By: Michel Cadot
A query that works in SquirrelSLQL fails in C# Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows By: Darth Waiter on Tue, 27 October 2020	4	5790	Wed, 28 October 2020 08:13 By: Darth Waiter
ORA-1403 when trying to select after Insert Oracle 10g By: pjizquierdo on Tue, 27 October 2020	4	5304	Wed, 28 October 2020 07:54 By: pjizquierdo
SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Mon, 26 October 2020	12	7445	Tue, 27 October 2020 18:43 By: Solomon Yakobson
temp table not returning data in WITH 18.10 By: radrodeo9 on Thu, 22 October 2020	11	7773	Sun, 25 October 2020 22:29 By: flyboy
Get Distinct Data Oracle By: james94539 on Sun, 25 October 2020	4	4601	Sun, 25 October 2020 12:51 By: Michel Cadot
Split Partition with Online / Update global indexes clause 11.2.0.4 By: azeem87 on Fri, 09 October 2020	19	11576	Thu, 22 October 2020 13:40 By: azeem87
To_char date with and without format 11.2.0.1.0 By: OraFerro on Thu, 22 October 2020	2	3729	Thu, 22 October 2020 06:35 By: Solomon Yakobson
Tree order, Sum of valid values Oracle 12.2.0. By: vasudevaviswa on Tue, 20 October 2020	2	3765	Tue, 20 October 2020 12:39 By: vasudevaviswa
How to generate a spool file without an extension name (.lst,.txt etc...) SQL By: senaubi_me on Sat, 02 February 2008	6	9178	Fri, 16 October 2020 08:15 By: EdStevens
Pivot using SQL in Oracle Oracle SQL Dev Version 17.3.1.279 By: calredd@yahoo.com on Thu, 15 October 2020	1	3131	Thu, 15 October 2020 10:23 By: Michel Cadot
ORA-06502 Oracle 12 C windows By: anncao on Tue, 13 October 2020	3	3566	Tue, 13 October 2020 18:51 By: Solomon Yakobson
converting Unix Time format to readable format By: talhaparvaiz@yahoo.com on Sun, 11 October 2020	9	7212	Mon, 12 October 2020 06:09 By: Solomon Yakobson
Matrix Report Out put Oracle 10 G, Windows7 By: hissam78 on Thu, 08 October 2020	5	4280	Sun, 11 October 2020 23:41 By: hissam78
REgexp_substr function to extract sub string By: talhaparvaiz@yahoo.com on Sun, 11 October 2020	2	3574	Sun, 11 October 2020 14:50 By: talhaparvaiz@yahoo.com
RANK issue in SQL By: aj123tx on Thu, 08 October 2020	3	4034	Sat, 10 October 2020 06:56 By: aj123tx
Improve efficiency of script 19.2.1.247 By: Dan22 on Tue, 06 October 2020	7	8681	Fri, 09 October 2020 03:30 By: John Watson
Duplicate delete condition 11.2 By: ritmo2k on Wed, 07 October 2020	6	4998	Thu, 08 October 2020 07:46 By: ritmo2k
OBJECT TYPE Body creation ERROR Oracle 19C, Window By: Bilal Khan on Thu, 08 October 2020	3	3264	Thu, 08 October 2020 05:57 By: Michel Cadot
Join Unique Tables By: selami on Wed, 07 October 2020	2	3391	Wed, 07 October 2020 07:36 By: John Watson
Loop with Dates PL/SQL (Windows/Current Oracle vers) By: Adjanti on Mon, 05 October 2020	4	3692	Tue, 06 October 2020 10:36 By: Michel Cadot
Row Generator Using MODEL Clause, # Repeats Table-Based? By: Art Metzer on Mon, 05 October 2020	2	3624	Tue, 06 October 2020 09:39 By: Art Metzer
Test Oracle SQL By: misterbean on Tue, 06 October 2020	2	3123	Tue, 06 October 2020 01:35 By: Michel Cadot
extract string and compare By: desmond30 on Mon, 05 October 2020	3	2991	Mon, 05 October 2020 15:24 By: desmond30
Pass cursor to Procedure 12.1 By: ora9a on Sun, 04 October 2020	5	3495	Mon, 05 October 2020 05:06 By: Michel Cadot
Group pivot column 11.2.0.1.0 By: OraFerro on Sun, 04 October 2020	13	4813	Mon, 05 October 2020 01:46 By: Michel Cadot
update column for the set of records By: mist598 on Tue, 29 September 2020	5	4614	Tue, 29 September 2020 07:12 By: Michel Cadot
find the next occurrence of an event based on another event SQL Developer 19.2.1 By: ac24 on Sat, 26 September 2020	2	4617	Sat, 26 September 2020 08:52 By: Solomon Yakobson
How to get a substring from a character on By: Mark70 on Fri, 25 September 2020	4	5146	Fri, 25 September 2020 10:44 By: Solomon Yakobson
Can't connect with new user created By: Mark70 on Tue, 30 June 2020	6	12837	Fri, 25 September 2020 03:45 By: John Watson
Date format with UTC By: Mark70 on Thu, 18 June 2020	4	12813	Fri, 25 September 2020 03:44 By: Mark70
How to use table functions By: Mark70 on Wed, 03 June 2020	4	12610	Fri, 25 September 2020 03:43 By: Mark70
How to add SOAP elements to XML Oracle 10g By: Mark70 on Mon, 01 June 2020	4	11598	Fri, 25 September 2020 03:43 By: Mark70
Finding entries missing a value and listing all used values for specific data By: magriii on Wed, 23 September 2020	6	5699	Thu, 24 September 2020 07:52 By: EdStevens
Query help on 5 tables. Oracle, 11g By: krajasekhar.n@gmail.com on Tue, 22 September 2020	4	5659	Tue, 22 September 2020 22:33 By: Iffat
Date interval Blank count Oracle 11 By: Marinus1979 on Wed, 16 September 2020	5	12383	Fri, 18 September 2020 10:07 By: Littlefoot
understanding table partition Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: wtolentino on Tue, 15 September 2020	9	12801	Thu, 17 September 2020 00:28 By: Michel Cadot
Invisible double quotes Oracle 12c Windows10 By: pstanand on Fri, 11 September 2020	8	15355	Wed, 16 September 2020 14:08 By: Michel Cadot
How to retrieve data only those which are in decimals oracle 12c By: lacchhii on Tue, 15 September 2020	4	11742	Tue, 15 September 2020 06:06 By: lacchhii