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
SQL to retrieve lines based on a static value By: 891ashok@gmail.com on Mon, 26 October 2020	12	6822	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	7107	Sun, 25 October 2020 22:29 By: flyboy
Get Distinct Data Oracle By: james94539 on Sun, 25 October 2020	4	4087	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	10438	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	3254	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	3286	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	8487	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	2683	Thu, 15 October 2020 10:23 By: Michel Cadot
ORA-06502 Oracle 12 C windows By: anncao on Tue, 13 October 2020	3	3073	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	6635	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	3761	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	3096	Sun, 11 October 2020 14:50 By: talhaparvaiz@yahoo.com
RANK issue in SQL By: aj123tx on Thu, 08 October 2020	3	3544	Sat, 10 October 2020 06:56 By: aj123tx
Improve efficiency of script 19.2.1.247 By: Dan22 on Tue, 06 October 2020	7	8226	Fri, 09 October 2020 03:30 By: John Watson
Duplicate delete condition 11.2 By: ritmo2k on Wed, 07 October 2020	6	4449	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	2720	Thu, 08 October 2020 05:57 By: Michel Cadot
Join Unique Tables By: selami on Wed, 07 October 2020	2	2959	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	3150	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	3196	Tue, 06 October 2020 09:39 By: Art Metzer
Test Oracle SQL By: misterbean on Tue, 06 October 2020	2	2663	Tue, 06 October 2020 01:35 By: Michel Cadot
extract string and compare By: desmond30 on Mon, 05 October 2020	3	2561	Mon, 05 October 2020 15:24 By: desmond30
Pass cursor to Procedure 12.1 By: ora9a on Sun, 04 October 2020	5	3023	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	4271	Mon, 05 October 2020 01:46 By: Michel Cadot
update column for the set of records By: mist598 on Tue, 29 September 2020	5	4076	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	4099	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	4554	Fri, 25 September 2020 10:44 By: Solomon Yakobson
Can't connect with new user created By: Mark70 on Tue, 30 June 2020	6	11677	Fri, 25 September 2020 03:45 By: John Watson
Date format with UTC By: Mark70 on Thu, 18 June 2020	4	11750	Fri, 25 September 2020 03:44 By: Mark70
How to use table functions By: Mark70 on Wed, 03 June 2020	4	11465	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	10460	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	5122	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	5135	Tue, 22 September 2020 22:33 By: Iffat
Date interval Blank count Oracle 11 By: Marinus1979 on Wed, 16 September 2020	5	11838	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	12250	Thu, 17 September 2020 00:28 By: Michel Cadot
Invisible double quotes Oracle 12c Windows10 By: pstanand on Fri, 11 September 2020	8	14440	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	11188	Tue, 15 September 2020 06:06 By: lacchhii
Sending email MS Word attachment containing Arabic letters 11.2.0.1.0 By: OraFerro on Sun, 06 September 2020	0	4286	Sun, 06 September 2020 04:24 By: OraFerro
outer query returning more than one row MS SQL By: kumarravik on Sat, 05 September 2020	2	4338	Sat, 05 September 2020 10:24 By: Michel Cadot
Foreign key By: ttornado on Wed, 02 September 2020	10	5451	Fri, 04 September 2020 12:56 By: EdStevens
to_timestamp_tz Oracle 12c Windows10 By: pstanand on Fri, 04 September 2020	4	3522	Fri, 04 September 2020 12:54 By: EdStevens