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 39801 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 339058 Sun, 29 January 2023 19:35
By: mathguy
  Left Outer Join Error (merged) (duplicate deleted by bb)
oracle
By: suji6281 on Wed, 05 June 2024
0 6252 Wed, 05 June 2024 08:13
By: suji6281
  Add Column with default existing column
By: deepakdot on Fri, 24 May 2024
10 19804 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 12972 Wed, 22 May 2024 07:46
By: Amine
  previous month
oracle
By: Sekhar6617 on Mon, 13 May 2024
5 21867 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 17019 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 10198 Sun, 12 May 2024 16:47
By: wtolentino
  PL SQL table generate auto index
Oracle 19C
By: sss111ind on Wed, 01 May 2024
3 17734 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 20611 Mon, 29 April 2024 04:11
By: Barbara Boehmer
  Missing records
Oracle SQL
By: ace_friends22 on Wed, 24 April 2024
3 16619 Wed, 24 April 2024 10:13
By: ace_friends22
  Condition based truncate partition
Oracle
By: ace_friends22 on Fri, 22 December 2023
3 30563 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 14544 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 7500 Mon, 22 April 2024 08:19
By: Amine
  Oracle ORA-00918: column ambiguously defined
19c
By: Unclefool on Tue, 16 April 2024
14 10289 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 13650 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 14618 Wed, 03 April 2024 11:02
By: Michel Cadot
  RETUNR FUNCTION USING "TYPE"
10G
By: emadnabil on Thu, 22 February 2024
3 24307 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 21965 Wed, 27 March 2024 12:12
By: Solomon Yakobson
  how to sum the amounts
By: suji6281 on Tue, 26 March 2024
6 17447 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 15675 Wed, 20 March 2024 12:22
By: cookiemonster
  Prevent user from executing a script until they will have read and understood it
18
By: Darth Waiter on Fri, 08 March 2024
7 19233 Tue, 12 March 2024 14:03
By: Darth Waiter
  BLOB Column with Zip File Convert to CLOB
Oracle, 19.0.0.0.0, Linux
By: Duane on Tue, 20 February 2024
9 16602 Fri, 01 March 2024 10:44
By: Michel Cadot
  update table attribute help!
By: ramys on Thu, 22 February 2024
3 17116 Thu, 22 February 2024 21:57
By: flyboy
  Query having multiple subqueries to be simplified
11g enterprise version
By: harishankar_kar on Tue, 20 February 2024
6 10389 Wed, 21 February 2024 04:34
By: cookiemonster
  Help needed in Tricky Group by
oracle 19c
By: born2achieve on Mon, 19 February 2024
2 3686 Tue, 20 February 2024 10:13
By: born2achieve
  Traverse CLOB with Connect By
Oracle, 19.0.0.0.0, Linux
By: Duane on Thu, 15 February 2024
25 18427 Sat, 17 February 2024 11:03
By: Duane
  Read BLOB from Table into CLOB for further processing
Oracle, 19.0.0.0.0, Linux
By: Duane on Tue, 13 February 2024
9 9895 Wed, 14 February 2024 13:26
By: Duane
  Xmlattribute not returning tag when the value is null
Oracle 19c
By: sss111ind on Fri, 09 February 2024
5 10698 Wed, 14 February 2024 03:08
By: sss111ind
  Creating Global vs Local Indexes for Partitioned Table
ORACLE 19c
By: oracle_search on Tue, 13 February 2024
4 8634 Wed, 14 February 2024 02:35
By: John Watson
  Querying table permissions to see which users have them
18
By: Darth Waiter on Mon, 05 February 2024
12 10019 Thu, 08 February 2024 13:49
By: Darth Waiter
  Dad, Grand Pa and Great Grand Pa !
11.2.0.3
By: Amine on Fri, 09 December 2022
7 46264 Wed, 07 February 2024 10:35
By: Amine
  oracle10g and utl_http
oracle10g
By: aabunarr on Sat, 03 February 2024
2 12206 Sun, 04 February 2024 09:25
By: Frank Naude
  Evaluating a sys_context call in a predicate
DB 19.22
By: John Watson on Wed, 31 January 2024
3 14630 Sat, 03 February 2024 02:13
By: John Watson
  What is the difference between varchar2 and nvarchar2?
Oracle 18 Windows Server 2016
By: Darth Waiter on Wed, 24 January 2024
10 24077 Sat, 27 January 2024 20:51
By: mathguy
  DBMS_OUTPUT how to include a white space
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0
By: wtolentino on Thu, 25 January 2024
2 18930 Thu, 25 January 2024 11:15
By: Michel Cadot
  VSIZE() function's meaning and physical storage size
18
By: Darth Waiter on Wed, 17 January 2024
12 21742 Fri, 19 January 2024 11:04
By: Darth Waiter
  Need help to build a query
Oracle12C
By: shabir46 on Wed, 17 January 2024
1 15310 Wed, 17 January 2024 12:12
By: Michel Cadot
  XML Create logic
By: vips2988 on Wed, 10 January 2024
3 16471 Thu, 11 January 2024 19:20
By: mathguy
  Grants of System Privileges Thru Stored Procedure
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0
By: wtolentino on Tue, 09 January 2024
2 13333 Tue, 09 January 2024 09:28
By: wtolentino
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: Sun Jun 23 06:44:16 CDT 2024