Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    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 43282 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 360933 Sun, 29 January 2023 19:35
By: mathguy
  How to Get the Program Name in 11g version
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: wtolentino on Fri, 08 November 2024
7 597 Sat, 09 November 2024 08:53
By: wtolentino
  SQL count with comma delimit
19c
By: born2achieve on Wed, 06 November 2024
5 778 Thu, 07 November 2024 08:56
By: born2achieve
  Date range comparison with hours, minutes and seconds
Oracle 19c
By: oracle12c_user on Wed, 23 October 2024
3 1559 Fri, 01 November 2024 01:11
By: oracle12c_user
  Problem with passing values to Function
Oracle 19.0.0.0.0 Windows 64bit
By: Duane on Wed, 30 October 2024
3 731 Thu, 31 October 2024 07:16
By: Duane
  Oracle Percentage by Rank(Top Percentages)
oracle 19c
By: born2achieve on Tue, 22 October 2024
2 1314 Wed, 23 October 2024 07:25
By: born2achieve
  Previous Quarter three months of Start Date and End Dates
SQL
By: suji6281 on Wed, 16 October 2024
6 3944 Thu, 17 October 2024 06:31
By: cookiemonster
  how to select Sub_Query fields
oracle
By: suji6281 on Sun, 13 October 2024
6 6256 Wed, 16 October 2024 12:22
By: suji6281
  SQL Macro using UTL_FILE
Oracle 19.0.0.0.0 Windows 64bit
By: Duane on Thu, 26 September 2024
32 14777 Wed, 09 October 2024 20:34
By: Duane
  PLS-00172: string literal too long while passing large XML as input to a procedure
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0
By: gopieee16 on Mon, 23 September 2024
5 9823 Sat, 28 September 2024 15:03
By: Michel Cadot
  How avoid More than one Join With Same table (merged)
Oracle, Windows 10
By: Nicha on Fri, 20 September 2024
7 11988 Wed, 25 September 2024 11:07
By: Nicha
  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
6 17437 Tue, 17 September 2024 19:05
By: PPOraFaq
  Get most recent Value in one row only. (6 merged)
ORACLE
By: Nicha on Wed, 11 September 2024
19 10721 Mon, 16 September 2024 11:58
By: Michel Cadot
  all the rows from two tables with conditions
Oracle
By: suji6281 on Fri, 16 August 2024
10 24540 Mon, 16 September 2024 05:58
By: cookiemonster
  remove comments from all_source output
10g r2
By: Kevin Meade on Thu, 27 March 2008
17 27752 Sat, 14 September 2024 10:31
By: Solomon Yakobson
  Query CLOB column with values in a Set List
Oracle 19.0.0.0.0 Windows 64bit
By: Duane on Wed, 04 September 2024
3 10498 Wed, 04 September 2024 12:14
By: Duane
  minimize the SELECT statements
oracle
By: suji6281 on Sun, 04 August 2024
8 27746 Fri, 16 August 2024 04:54
By: cookiemonster
  diffrence between two chacter fields.
By: shahzad-ul-hasan on Wed, 07 August 2024
5 22221 Tue, 13 August 2024 01:22
By: Littlefoot
  specific text from the string
oracle
By: suji6281 on Tue, 30 July 2024
7 25619 Sun, 04 August 2024 12:51
By: suji6281
  schedule is not running
Oracle 10g
By: emadnabil on Tue, 09 July 2024
3 15347 Tue, 09 July 2024 06:42
By: emadnabil
  Left Outer Join Error (merged) (duplicate deleted by bb)
oracle
By: suji6281 on Wed, 05 June 2024
0 12284 Wed, 05 June 2024 08:13
By: suji6281
  Add Column with default existing column
By: deepakdot on Fri, 24 May 2024
10 32081 Tue, 28 May 2024 04:50
By: cookiemonster
  More precision about log errors
11.2.0.3
By: Amine on Wed, 22 May 2024
0 18215 Wed, 22 May 2024 07:46
By: Amine
  previous month
oracle
By: Sekhar6617 on Mon, 13 May 2024
5 26468 Mon, 20 May 2024 22:16
By: mathguy
  Get the MetaData for FGA Policy
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Tue, 14 May 2024
3 20738 Thu, 16 May 2024 14:18
By: wtolentino
  ORA-30372: fine grain access policy conflicts with materialized view
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Fri, 10 May 2024
4 14264 Sun, 12 May 2024 16:47
By: wtolentino
  PL SQL table generate auto index
Oracle 19C
By: sss111ind on Wed, 01 May 2024
3 21333 Wed, 01 May 2024 09:36
By: Barbara Boehmer
  insert data from csv file
oracle 19c, windows 11
By: jimut on Mon, 29 April 2024
2 24409 Mon, 29 April 2024 04:11
By: Barbara Boehmer
  Missing records
Oracle SQL
By: ace_friends22 on Wed, 24 April 2024
3 20062 Wed, 24 April 2024 10:13
By: ace_friends22
  Condition based truncate partition
Oracle
By: ace_friends22 on Fri, 22 December 2023
3 33845 Wed, 24 April 2024 10:09
By: ace_friends22
  Convert input from user into UPPERCASE
Oracle SQL
By: watisditnou@msn.com on Tue, 16 April 2024
6 19020 Wed, 24 April 2024 03:34
By: John Watson
  Getting ancestors in hierarchies
11.2.0.3.0
By: Amine on Sat, 20 April 2024
7 12103 Mon, 22 April 2024 08:19
By: Amine
  Oracle ORA-00918: column ambiguously defined
19c
By: Unclefool on Tue, 16 April 2024
14 17167 Wed, 17 April 2024 17:31
By: Barbara Boehmer
  correct treatment of date across different timezones
Oracle 19
By: jansulc on Thu, 04 April 2024
5 17768 Thu, 04 April 2024 06:27
By: jansulc
icon8.gif Implement Profile, PW Policy & Roles
Oracle SQL Developer (XE) -
By: noname369 on Tue, 02 April 2024
7 19256 Wed, 03 April 2024 11:02
By: Michel Cadot
  RETUNR FUNCTION USING "TYPE"
10G
By: emadnabil on Thu, 22 February 2024
3 27724 Fri, 29 March 2024 07:08
By: emadnabil
  Getting same sequence number in select query
Oracle 19c
By: sss111ind on Tue, 12 March 2024
7 26684 Wed, 27 March 2024 12:12
By: Solomon Yakobson
  how to sum the amounts
By: suji6281 on Tue, 26 March 2024
6 21697 Tue, 26 March 2024 09:56
By: suji6281
  Do users ever create tables in these schemas?
18
By: Darth Waiter on Sun, 17 March 2024
18 22978 Wed, 20 March 2024 12:22
By: cookiemonster
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue Nov 12 16:20:56 CST 2024