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	1	31326	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	47	312652	Sun, 29 January 2023 19:35 By: mathguy
Duplicate rows by generating date based on column value 12.1.0.1.0 By: OraFerro on Mon, 30 January 2023	18	2939	Tue, 31 January 2023 23:02 By: OraFerro
Help need in writing query to get JSON format output Oracle 19c By: pr76666 on Mon, 30 January 2023	2	1313	Tue, 31 January 2023 01:06 By: Michel Cadot
xml auto generate atribute 19c By: mape on Wed, 18 January 2023	5	10238	Tue, 31 January 2023 00:27 By: mathguy
Get customer with GREATEST amount of purchases By: Unclefool on Sun, 29 January 2023	12	2488	Mon, 30 January 2023 09:55 By: mathguy
REST API with DDOS protection ORACLE 12c By: mmation on Fri, 17 November 2017	3	4665	Mon, 30 January 2023 07:26 By: rxelgin
Two Column Join Oracle PL SQL By: ibrahimzuberi on Fri, 27 January 2023	9	7454	Mon, 30 January 2023 00:30 By: ibrahimzuberi
greatest total amount of purchases per day for each customer_id By: Unclefool on Sat, 14 January 2023	3	14071	Tue, 17 January 2023 02:11 By: Michel Cadot
SQL very slow EBS R12.2.8 By: ccpCCP88 on Tue, 10 January 2023	16	18089	Mon, 16 January 2023 10:59 By: Duane
Base64 to Blob Oracle, 12.2.0.1.0, Linux By: Duane on Thu, 12 January 2023	2	13702	Thu, 12 January 2023 15:20 By: Duane
Row Level trigger By: indupriyav_2023 on Wed, 11 January 2023	1	11544	Wed, 11 January 2023 04:09 By: Michel Cadot
COALESCE and CASE By: questvba on Tue, 03 January 2023	5	14688	Wed, 04 January 2023 07:57 By: Michel Cadot
xml error eurofxref-daily.xml 19c By: mape on Sun, 01 January 2023	7	15358	Sun, 01 January 2023 07:57 By: Solomon Yakobson
Dad, Grand Pa and Great Grand Pa ! 11.2.0.3 By: Amine on Fri, 09 December 2022	2	34994	Wed, 21 December 2022 07:54 By: _jum
Parent/Child Table Design Help Oracle, 12.2.0.1.0, Linux By: Duane on Tue, 20 December 2022	1	22097	Wed, 21 December 2022 01:17 By: John Watson
Months Calculation and update Statement Oracle 11G, Windows By: hissam78 on Sat, 10 December 2022	5	40068	Sun, 11 December 2022 13:02 By: Michel Cadot
String Extract using REGEXP_SUBSTR Oracle, 12.2.0.1.0, Linux By: Duane on Fri, 09 December 2022	6	35757	Sat, 10 December 2022 15:05 By: Solomon Yakobson
Update difference between two dates in months Oracle 11 G, Windows By: hissam78 on Wed, 07 December 2022	3	33277	Fri, 09 December 2022 18:10 By: hissam78
Value multiple Sql Plus, Oracle 10G, Windows By: hissam78 on Fri, 25 November 2022	14	32546	Wed, 07 December 2022 17:02 By: hissam78
Performance issue with Update statement having select Statement By: VVR on Thu, 01 December 2022	4	20697	Tue, 06 December 2022 01:00 By: John Watson
Function not working Oracle 10G, Windows By: hissam78 on Tue, 29 November 2022	6	21949	Sat, 03 December 2022 00:37 By: Michel Cadot
Find row count after update Oracle 12c, Linux By: rajiv.oradev on Fri, 18 November 2022	11	18272	Wed, 23 November 2022 18:47 By: rajiv.oradev
unique timestamp By: deepakdot on Tue, 15 November 2022	8	12732	Mon, 21 November 2022 05:57 By: deepakdot
Row into Column and sum two columns Oracle 10 G, Windows By: hissam78 on Tue, 15 November 2022	0	9260	Tue, 15 November 2022 09:39 By: hissam78
Refreshing Materialized View oracle 10g By: chat2raj.s on Sun, 13 November 2022	1	5878	Tue, 15 November 2022 01:11 By: John Watson
RegEX data parsing 12.1 By: lott42_gmail on Thu, 10 November 2022	5	10069	Mon, 14 November 2022 11:48 By: lott42_gmail
Dynamic Procedure To Drop A Database Link Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 09 November 2022	6	6790	Thu, 10 November 2022 17:01 By: Solomon Yakobson
JOIN with cte By: Unclefool on Tue, 08 November 2022	1	4459	Wed, 09 November 2022 01:25 By: Michel Cadot
Pivot query 19c By: glmjoy on Mon, 07 November 2022	3	4332	Tue, 08 November 2022 12:42 By: glmjoy
INSERT SELECT not working By: Unclefool on Tue, 01 November 2022	6	8879	Wed, 02 November 2022 04:19 By: John Watson
ORA-29005: The certificate is invalid Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0 By: fixxxer on Mon, 24 October 2022	0	8063	Mon, 24 October 2022 04:57 By: fixxxer
bulk date update add months (merged) pl/sql By: rhnshk on Thu, 20 October 2022	1	7780	Fri, 21 October 2022 14:31 By: Solomon Yakobson
Dynamic Source Table & Target Table By: aimy on Tue, 11 October 2022	7	6373	Sat, 15 October 2022 11:56 By: aimy
Fine Grain Access Policy Oracle, 12.2.0.1.0, Linux By: Duane on Wed, 12 October 2022	2	5216	Thu, 13 October 2022 20:01 By: Duane
xml generate from db on redaction column Oracle 12 C 2 By: sss111ind on Wed, 12 October 2022	2	3973	Wed, 12 October 2022 04:36 By: sss111ind
Need a trigger or similar thing Oracle Database version 19.12.0.0.0 By: Only-Oracle on Mon, 26 September 2022	5	11068	Fri, 07 October 2022 22:42 By: Only-Oracle
trigger executing a procedure to execute dbms_stats.gather_table_stats Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 28 September 2022	5	9388	Mon, 03 October 2022 08:08 By: wtolentino
Columns replicate Oracle 12c By: rajivn786 on Fri, 30 September 2022	2	5710	Sat, 01 October 2022 09:55 By: rajivn786
Procedure Parameter List Oracle, 12.2.0.1.0, Linux By: Duane on Wed, 28 September 2022	7	7823	Fri, 30 September 2022 16:17 By: Duane