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
Announcement: How to use [code] tags and make your code easier to read By: Michel Cadot on Thu, 01 November 2018	2	17357	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	43	246603	Tue, 06 November 2018 14:17 By: Solomon Yakobson
Weird PL/SQL behavior with SQL statement containing a function in WITH clause 12.1 to 19.8 By: Michel Cadot on Fri, 15 January 2021	0	2037	Fri, 15 January 2021 13:39 By: Michel Cadot
After "Drop Materialized View" it's data continuing be shown Oracle Database 12c EE 12.2.0.1.0 on Windows 64bit By: jrgOra on Tue, 12 January 2021	4	3145	Wed, 13 January 2021 17:21 By: jrgOra
Substring Query in Oracle SQL Oracle 11g By: abhayman on Fri, 08 January 2021	8	9209	Fri, 08 January 2021 06:35 By: Solomon Yakobson
DBMS_HS_PASSTHROUGH - Database Link as Input Parameter By: aimy on Wed, 06 January 2021	8	8114	Fri, 08 January 2021 00:35 By: Michel Cadot
Regex Help By: ssmith001 on Thu, 07 January 2021	2	9901	Thu, 07 January 2021 12:56 By: ssmith001
opening and closing balance oracle 19c By: learner123 on Thu, 07 January 2021	4	6900	Thu, 07 January 2021 06:36 By: learner123
SQL query. Oracle 11g. By: akarra21 on Mon, 28 December 2020	10	7708	Wed, 06 January 2021 00:02 By: Michel Cadot
oracle pl/sql 11g By: thirunakar ramesh on Mon, 04 January 2021	1	2157	Mon, 04 January 2021 11:27 By: Michel Cadot
Fuzzy Matching S-Q-L Sever Taking Fime for 2.4 millions records By: mohsin_zee on Thu, 31 December 2020	1	5609	Thu, 31 December 2020 14:26 By: Michel Cadot
sending bulk email in Report 12c? Report 12c By: Dhabhu on Wed, 30 December 2020	0	2649	Wed, 30 December 2020 00:21 By: Dhabhu
Partitoning taking long time Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: sss111ind on Tue, 15 December 2020	5	5323	Thu, 24 December 2020 13:04 By: Solomon Yakobson
DBMS_HS_PASSTHROUGH - Column Value Truncated SQL*Plus: Release 11.2.0.1.0 [Server version: 5.7.29-5-log MySQL Community Server - (GPL)] By: aimy on Mon, 21 December 2020	0	3361	Mon, 21 December 2020 10:38 By: aimy
ORA 08103 - object no longer exists referring a temporary table By: NZZ on Fri, 18 December 2020	1	1756	Fri, 18 December 2020 10:56 By: Michel Cadot
Insufficient privileges? By: Nicola Farina on Thu, 15 November 2001	5	4325	Fri, 18 December 2020 01:25 By: Michel Cadot
Mix of Cross and Full Outer Join https://livesql.oracle.com/apex By: manubatham20 on Tue, 15 December 2020	5	3767	Wed, 16 December 2020 02:02 By: Michel Cadot
tab_to_string for longer texts ORA-06502-numeric or value error string By: rafalbballer on Tue, 01 December 2020	9	6344	Wed, 16 December 2020 01:37 By: rafalbballer
Ora-06502 error for json_value (merged) Oracle 12 By: talhaparvaiz@yahoo.com on Sun, 13 December 2020	8	2891	Mon, 14 December 2020 15:07 By: Michel Cadot
Display Numeric Value from Text Field Oracle 10 G, Windows7 By: hissam78 on Fri, 11 December 2020	4	5349	Sun, 13 December 2020 00:31 By: Michel Cadot
XML into one row 12.1.0.2 By: mape on Wed, 09 December 2020	7	3564	Wed, 09 December 2020 07:06 By: mape
ten-digit hexadecimal number 12.1.0.2.0 By: mape on Tue, 01 December 2020	8	4793	Wed, 09 December 2020 06:10 By: mape
REGEXP_REPLACE Oracle 12c By: sss111ind on Tue, 08 December 2020	2	1058	Tue, 08 December 2020 23:47 By: sss111ind
string_api package that... has no body? Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production 0 Windows By: Darth Waiter on Wed, 02 December 2020	22	6332	Tue, 08 December 2020 18:28 By: flyboy
Help for a noobie! By: nail3r on Thu, 03 December 2020	1	3530	Thu, 03 December 2020 04:17 By: Michel Cadot
Need help to rewrite the query 11G By: nikhiljuneja@gmail.com on Mon, 30 November 2020	4	2533	Tue, 01 December 2020 00:27 By: nikhiljuneja@gmail.com
week start from saturday oracle 10g, windows 7 By: hissam78 on Sat, 28 November 2020	7	3948	Tue, 01 December 2020 00:17 By: Michel Cadot
How to convert JSON into XML in Oracle 10g By: Mark70 on Mon, 30 November 2020	1	2408	Mon, 30 November 2020 05:45 By: Michel Cadot
Creating Procedure (2 merged) Windows 10, Oracle Express Edition 10g, Developer 10g By: shahzaib_4vip@hotmail.com on Sun, 29 November 2020	1	3655	Sun, 29 November 2020 04:21 By: Michel Cadot
Table joining with two columns sharing a foreign key By: richard_blaq on Thu, 26 November 2020	2	3162	Fri, 27 November 2020 05:43 By: Solomon Yakobson
One row for multiple rows based on a condition By: annacol on Wed, 25 November 2020	2	3637	Thu, 26 November 2020 00:07 By: Michel Cadot
Day book format oracle 10g, windows 7 By: hissam78 on Tue, 24 November 2020	9	4306	Tue, 24 November 2020 10:43 By: Michel Cadot
Need SQL Logic For Comparing Data Between Two Tabless Oracle By: nrk1979 on Fri, 20 November 2020	3	7289	Sat, 21 November 2020 07:30 By: Solomon Yakobson
Query with LIKE too SLOW... By: aimy on Fri, 20 November 2020	9	6783	Fri, 20 November 2020 10:16 By: Michel Cadot
UPDATE query with three table join (3 merged) oracle sql By: harshitawk on Tue, 10 November 2020	4	3364	Wed, 18 November 2020 16:07 By: flyboy
Count of records with the max(date) and Max(lastrecordid) SQL By: enniwesw on Thu, 12 November 2020	2	4890	Tue, 17 November 2020 02:46 By: enniwesw
Date to Jewish/Hebrew Date (2 merged) By: LiorI on Sun, 15 November 2020	2	3981	Sun, 15 November 2020 03:47 By: Michel Cadot
Extract words from a string and use them as variables oracle By: Haykel_bh on Fri, 13 November 2020	5	2988	Sat, 14 November 2020 00:24 By: Michel Cadot
table refresh process - discuss optoins 12.2 By: talhaparvaiz@yahoo.com on Thu, 12 November 2020	8	5445	Fri, 13 November 2020 01:22 By: John Watson
table record into XML user defined (2 merged) By: mape on Wed, 11 November 2020	8	2616	Wed, 11 November 2020 08:14 By: mape