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 38949 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 337204 Sun, 29 January 2023 19:35
By: mathguy
How to create menu using database table (2 topics merged, duplicate deleted, moved to Forms by bb) has been moved to Forms by the moderator.
  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 8462 Thu, 16 May 2024 14:18
By: wtolentino
  previous month
oracle
By: Sekhar6617 on Mon, 13 May 2024
4 8193 Tue, 14 May 2024 04:05
By: cookiemonster
  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 9205 Sun, 12 May 2024 16:47
By: wtolentino
  PL SQL table generate auto index
Oracle 19C
By: sss111ind on Wed, 01 May 2024
3 16838 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 19703 Mon, 29 April 2024 04:11
By: Barbara Boehmer
  Missing records
Oracle SQL
By: ace_friends22 on Wed, 24 April 2024
3 15837 Wed, 24 April 2024 10:13
By: ace_friends22
  Condition based truncate partition
Oracle
By: ace_friends22 on Fri, 22 December 2023
3 29806 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 13760 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 6759 Mon, 22 April 2024 08:19
By: Amine
  Oracle ORA-00918: column ambiguously defined
19c
By: Unclefool on Tue, 16 April 2024
14 9487 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 12899 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 13811 Wed, 03 April 2024 11:02
By: Michel Cadot
  RETUNR FUNCTION USING "TYPE"
10G
By: emadnabil on Thu, 22 February 2024
3 23547 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 21112 Wed, 27 March 2024 12:12
By: Solomon Yakobson
  how to sum the amounts
By: suji6281 on Tue, 26 March 2024
6 16599 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 14799 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 18493 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 15840 Fri, 01 March 2024 10:44
By: Michel Cadot
  update table attribute help!
By: ramys on Thu, 22 February 2024
3 16433 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 9707 Wed, 21 February 2024 04:34
By: cookiemonster
  Help needed in Tricky Group by
oracle 19c
By: born2achieve on Mon, 19 February 2024
2 3039 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 17674 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 9142 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 10034 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 7977 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 9336 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 45601 Wed, 07 February 2024 10:35
By: Amine
  oracle10g and utl_http
oracle10g
By: aabunarr on Sat, 03 February 2024
2 11549 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 14000 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 23316 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 18303 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 21004 Fri, 19 January 2024 11:04
By: Darth Waiter
  Need help to build a query
Oracle12C
By: shabir46 on Wed, 17 January 2024
1 14685 Wed, 17 January 2024 12:12
By: Michel Cadot
  XML Create logic
By: vips2988 on Wed, 10 January 2024
3 15799 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 12709 Tue, 09 January 2024 09:28
By: wtolentino
  plsql writen test questions
oracle 18
By: bammidi on Sun, 07 January 2024
4 14670 Mon, 08 January 2024 09:07
By: bammidi
  Partition
19c
By: babuknb on Thu, 07 December 2023
6 27140 Sun, 07 January 2024 12:26
By: babuknb
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: Mon May 20 10:45:20 CDT 2024