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
bulk date update add months (merged) pl/sql By: rhnshk on Thu, 20 October 2022	1	12129	Fri, 21 October 2022 14:31 By: Solomon Yakobson
Dynamic Source Table & Target Table By: aimy on Tue, 11 October 2022	7	12497	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	10547	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	8745	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	16519	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	15546	Mon, 03 October 2022 08:08 By: wtolentino
Columns replicate Oracle 12c By: rajivn786 on Fri, 30 September 2022	2	10136	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	16484	Fri, 30 September 2022 16:17 By: Duane
ANSI JOIN requirement By: nishant1987 on Fri, 30 September 2022	1	8865	Fri, 30 September 2022 09:13 By: Michel Cadot
Sql is causing performance issue By: nishant1987 on Tue, 27 September 2022	1	7615	Wed, 28 September 2022 01:15 By: John Watson
INDEX hint DB 19.3 By: John Watson on Mon, 26 September 2022	2	7842	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	22008	Thu, 22 September 2022 10:20 By: cookiemonster
XMLTABLE - Multiple children By: questvba on Tue, 19 July 2022	15	27110	Mon, 19 September 2022 22:20 By: ananyaa
Combine 2 fields when using Groupby (merged) Oracle DB 18c By: halifaxns on Tue, 13 September 2022	8	20281	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	11943	Tue, 13 September 2022 01:31 By: shawaj
Where is the session timeout value for the duration of running an sql query/procedure By: Bob Alston on Wed, 07 September 2022	3	13104	Thu, 08 September 2022 02:51 By: Michel Cadot
PIPE ROW Oracle, 12.2, Unix By: Duane on Thu, 04 August 2022	7	25610	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	24834	Tue, 16 August 2022 08:51 By: Michel Cadot
trigger not update the column 19c By: mape on Mon, 18 July 2022	4	15294	Fri, 12 August 2022 08:35 By: Frank
Audit Database Problem By: Mooza on Wed, 03 August 2022	1	14082	Wed, 03 August 2022 10:38 By: Michel Cadot
Create comma delimited function 19.2 By: Unclefool on Wed, 27 July 2022	5	17399	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	16151	Wed, 27 July 2022 12:21 By: John Watson
Plsql function testing years 19.2 By: Unclefool on Thu, 21 July 2022	2	10290	Thu, 21 July 2022 12:42 By: Michel Cadot
Need to derive YTD,MAT,MQT oracle By: samiran_cts on Wed, 20 July 2022	4	11351	Wed, 20 July 2022 11:59 By: samiran_cts
Plsql using NVL 19.2 By: Unclefool on Tue, 19 July 2022	2	7949	Tue, 19 July 2022 15:01 By: Unclefool
Integrity constraint violation 19.2 By: Unclefool on Wed, 13 July 2022	2	16561	Wed, 13 July 2022 01:14 By: Unclefool
Sporadic Certification Validation Error While accessing the external portal Oracle Database 12c Release 12.1.0.2 - 64bit Production, AIX 7.2 By: jesuisantony on Fri, 10 June 2022	4	17390	Sun, 10 July 2022 03:28 By: jesuisantony
Teachers teaching the most students 19.2 By: Unclefool on Sun, 03 July 2022	10	22816	Sun, 10 July 2022 02:43 By: Michel Cadot
Replace column Value 12c By: deepakdot on Thu, 30 June 2022	8	18221	Fri, 01 July 2022 08:59 By: deepakdot
SENDGRID \| Curl Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production By: vippysharma on Thu, 16 December 2021	10	30885	Thu, 30 June 2022 04:36 By: thiyagarajancs
BASIC SYNTAX / Dynamic Pivot Table (merged) PL SQL By: Dhoback on Tue, 28 June 2022	20	31505	Thu, 30 June 2022 00:24 By: Michel Cadot
How to update multiple rows with different values from another table in the same query? Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: a_naq on Thu, 23 June 2022	4	15934	Thu, 23 June 2022 10:46 By: a_naq
Display average as part of result 19.2 By: Unclefool on Thu, 23 June 2022	2	12501	Thu, 23 June 2022 06:51 By: Unclefool
orapki: add crt and key to wallet Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0, Redhat Linux 6 By: fixxxer on Wed, 22 June 2022	6	21429	Wed, 22 June 2022 13:33 By: John Watson
Decode used in conjunction with sign Oracle 19c By: Solomon Yakobson on Fri, 10 June 2022	4	17549	Sat, 11 June 2022 18:16 By: kkaschke
Directory Name with UTL_FILE.FOPEN() Oracle, 12.2, Unix By: Duane on Fri, 03 June 2022	19	28958	Wed, 08 June 2022 13:36 By: Duane
List of partitions 12c By: azeem87 on Tue, 07 June 2022	6	10479	Wed, 08 June 2022 11:20 By: Solomon Yakobson
file transfer mechanism (FTP/SFTP/SSHFTP) using purely PL/SQL Oracle 19c database By: vaibhav8080 on Mon, 06 June 2022	6	13228	Mon, 06 June 2022 13:03 By: vaibhav8080
ORA-02270 on FK creation attempt Oracle 19c R2 Standard Edition 2 Linux By: Andrey_R on Sun, 05 June 2022	6	10935	Mon, 06 June 2022 04:47 By: Andrey_R
Trigger created with compilation errors (invalid specification trigger) SQL plus By: Syaz on Thu, 02 June 2022	2	11214	Fri, 03 June 2022 00:46 By: Michel Cadot