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	30212	Tue, 30 June 2020 11:23 By: Michel Cadot
sticky: Row generator ( 1 2) By: Michel Cadot on Thu, 03 January 2008	46	306382	Thu, 21 April 2022 01:05 By: khawja_bilalahmed
Function not working Oracle 10G, Windows By: hissam78 on Tue, 29 November 2022	1	1299	Tue, 29 November 2022 05:43 By: Michel Cadot
Value multiple Sql Plus, Oracle 10G, Windows By: hissam78 on Fri, 25 November 2022	9	6667	Tue, 29 November 2022 02:37 By: hissam78
Find row count after update Oracle 12c, Linux By: rajiv.oradev on Fri, 18 November 2022	11	16122	Wed, 23 November 2022 18:47 By: rajiv.oradev
unique timestamp By: deepakdot on Tue, 15 November 2022	8	10569	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	8794	Tue, 15 November 2022 09:39 By: hissam78
Refreshing Materialized View oracle 10g By: chat2raj.s on Sun, 13 November 2022	1	5360	Tue, 15 November 2022 01:11 By: John Watson
RegEX data parsing 12.1 By: lott42_gmail on Thu, 10 November 2022	5	9265	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	5837	Thu, 10 November 2022 17:01 By: Solomon Yakobson
JOIN with cte By: Unclefool on Tue, 08 November 2022	1	3899	Wed, 09 November 2022 01:25 By: Michel Cadot
Pivot query 19c By: glmjoy on Mon, 07 November 2022	3	3532	Tue, 08 November 2022 12:42 By: glmjoy
INSERT SELECT not working By: Unclefool on Tue, 01 November 2022	6	7724	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	7387	Mon, 24 October 2022 04:57 By: fixxxer
bulk date update add months (merged) pl/sql By: rhnshk on Thu, 20 October 2022	1	7054	Fri, 21 October 2022 14:31 By: Solomon Yakobson
Dynamic Source Table & Target Table By: aimy on Tue, 11 October 2022	7	5442	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	4521	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	3316	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	10276	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	8553	Mon, 03 October 2022 08:08 By: wtolentino
Columns replicate Oracle 12c By: rajivn786 on Fri, 30 September 2022	2	5121	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	6994	Fri, 30 September 2022 16:17 By: Duane
ANSI JOIN requirement By: nishant1987 on Fri, 30 September 2022	1	4377	Fri, 30 September 2022 09:13 By: Michel Cadot
Sql is causing performance issue By: nishant1987 on Tue, 27 September 2022	1	3294	Wed, 28 September 2022 01:15 By: John Watson
INDEX hint DB 19.3 By: John Watson on Mon, 26 September 2022	2	3095	Mon, 26 September 2022 08:40 By: John Watson
Calling shell scripts from dbms_scheduler Oracle 12.1.0.2.0, Red Hat 7.6 By: cookiemonster on Wed, 21 September 2022	15	8176	Thu, 22 September 2022 10:20 By: cookiemonster
Min and Max values of contiguous rows (3 merged) oracle 10g By: arun888 on Wed, 29 June 2022	10	13605	Thu, 22 September 2022 04:34 By: Michel Cadot
XMLTABLE - Multiple children By: questvba on Tue, 19 July 2022	15	13090	Mon, 19 September 2022 22:20 By: ananyaa
How to send email with OAuth (merged) Oracle, 12.1, Enterprise Edition, Linux By: praveenpraj on Thu, 15 September 2022	2	11537	Fri, 16 September 2022 13:35 By: Alien
Combine 2 fields when using Groupby (merged) Oracle DB 18c By: halifaxns on Tue, 13 September 2022	8	12280	Wed, 14 September 2022 14:22 By: halifaxns
Running Balance Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: shawaj on Mon, 12 September 2022	7	5404	Tue, 13 September 2022 01:31 By: shawaj
Consuming Rest API from PL/SQL using UTL_HTTP - body not recognized 11.2.0.4.0 By: skfaheem024 on Thu, 08 September 2022	3	7143	Sat, 10 September 2022 01:11 By: skfaheem024
Where is the session timeout value for the duration of running an sql query/procedure By: Bob Alston on Wed, 07 September 2022	3	7422	Thu, 08 September 2022 02:51 By: Michel Cadot
PIPE ROW Oracle, 12.2, Unix By: Duane on Thu, 04 August 2022	7	17681	Sat, 27 August 2022 05:22 By: Solomon Yakobson
Retrieve last month running total when current month is null ORACLE 11G By: Lim on Tue, 16 August 2022	8	17390	Tue, 16 August 2022 08:51 By: Michel Cadot
trigger not update the column 19c By: mape on Mon, 18 July 2022	4	9354	Fri, 12 August 2022 08:35 By: Frank
Audit Database Problem By: Mooza on Wed, 03 August 2022	1	9735	Wed, 03 August 2022 10:38 By: Michel Cadot
Create comma delimited function 19.2 By: Unclefool on Wed, 27 July 2022	5	11226	Thu, 28 July 2022 08:31 By: Michel Cadot
Problem in partition exchange Oracle 12 C 2 By: sss111ind on Wed, 27 July 2022	5	9975	Wed, 27 July 2022 12:21 By: John Watson
Plsql function testing years 19.2 By: Unclefool on Thu, 21 July 2022	2	6220	Thu, 21 July 2022 12:42 By: Michel Cadot