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
OBJECT TYPE Body creation ERROR Oracle 19C, Window By: Bilal Khan on Thu, 08 October 2020	3	1890	Thu, 08 October 2020 05:57 By: Michel Cadot
Join Unique Tables By: selami on Wed, 07 October 2020	2	2150	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	2278	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	2214	Tue, 06 October 2020 09:39 By: Art Metzer
Test Oracle SQL By: misterbean on Tue, 06 October 2020	2	1882	Tue, 06 October 2020 01:35 By: Michel Cadot
extract string and compare By: desmond30 on Mon, 05 October 2020	3	1807	Mon, 05 October 2020 15:24 By: desmond30
Pass cursor to Procedure 12.1 By: ora9a on Sun, 04 October 2020	5	2382	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	3000	Mon, 05 October 2020 01:46 By: Michel Cadot
update column for the set of records By: mist598 on Tue, 29 September 2020	5	3140	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	3160	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	3417	Fri, 25 September 2020 10:44 By: Solomon Yakobson
Can't connect with new user created By: Mark70 on Tue, 30 June 2020	6	9228	Fri, 25 September 2020 03:45 By: John Watson
Date format with UTC By: Mark70 on Thu, 18 June 2020	4	9645	Fri, 25 September 2020 03:44 By: Mark70
How to use table functions By: Mark70 on Wed, 03 June 2020	4	8973	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	8065	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	3864	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	4214	Tue, 22 September 2020 22:33 By: Iffat
Date interval Blank count Oracle 11 By: Marinus1979 on Wed, 16 September 2020	5	10541	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	10681	Thu, 17 September 2020 00:28 By: Michel Cadot
Invisible double quotes Oracle 12c Windows10 By: pstanand on Fri, 11 September 2020	8	11743	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	10165	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	3556	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	3752	Sat, 05 September 2020 10:24 By: Michel Cadot
Foreign key By: ttornado on Wed, 02 September 2020	10	4511	Fri, 04 September 2020 12:56 By: EdStevens
to_timestamp_tz Oracle 12c Windows10 By: pstanand on Fri, 04 September 2020	4	2502	Fri, 04 September 2020 12:54 By: EdStevens
xml to json conversion Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: wantmannu on Thu, 03 September 2020	1	2462	Fri, 04 September 2020 05:11 By: Solomon Yakobson
Oracle: create a partition by reference (partition by reference(fk)) on non referenced table By: yarfaoui on Tue, 01 September 2020	1	3563	Tue, 01 September 2020 04:57 By: John Watson
Oracle Procedure with table name as parameter Oracle 11g By: sunilpatro08 on Wed, 26 August 2020	11	6410	Fri, 28 August 2020 06:01 By: sunilpatro08
Future PriceCalculation based on 3 columns Oracle 11 By: buzzi7 on Wed, 19 August 2020	2	9136	Thu, 27 August 2020 00:18 By: Michel Cadot
row_number with duplicity 12.1.0.2.0 By: mape on Wed, 26 August 2020	3	2654	Wed, 26 August 2020 07:58 By: mape
Find out how long is the field or column By: james94539 on Thu, 06 August 2020	2	5673	Mon, 24 August 2020 08:51 By: Bill B
ORA-29279: SMTP permanent error (split from hijacked topic) By: samsam on Sat, 22 August 2020	2	6487	Sat, 22 August 2020 13:28 By: EdStevens
Select and load CLOB column data into another table Oracle 11g By: pmreddy.mahi@gmail.com on Wed, 19 August 2020	3	8182	Wed, 19 August 2020 08:10 By: Michel Cadot
SQL CASE or IF Else Condition DB 12C By: wasimK on Mon, 17 August 2020	2	3918	Mon, 17 August 2020 13:38 By: Solomon Yakobson
regexp_substr fix string unable to handle. Oracle, 11g, Windows 7 By: nitesh.erp@gmail.com on Sun, 16 August 2020	16	3744	Sun, 16 August 2020 23:28 By: nitesh.erp@gmail.com
dbms_output.put_line synchronize Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 14 August 2020	4	2912	Fri, 14 August 2020 13:15 By: Michel Cadot
min / max date of grouped status of a values ? (merged) oracle enterprise rdbms 18.3, linux64 By: flat on Thu, 13 August 2020	6	3366	Thu, 13 August 2020 09:33 By: flat
update foreign key of all the referenced table of table By: sinha73 on Mon, 10 August 2020	0	2601	Mon, 10 August 2020 23:26 By: sinha73
Errors running Proc that compiles fine SQL Developer Version 17.3.2.341 \ Build 341.0937 By: cfairtp on Fri, 07 August 2020	9	7335	Fri, 07 August 2020 15:44 By: Solomon Yakobson
INSERT WHEN NOT EXIST 12c By: deepakdot on Thu, 06 August 2020	6	5094	Fri, 07 August 2020 03:23 By: deepakdot