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 37701 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
47 334147 Sun, 29 January 2023 19:35
By: mathguy
  update table attribute help!
By: ramys on Thu, 22 February 2024
3 670 Thu, 22 February 2024 21:57
By: flyboy
  RETUNR FUNCTION USING "TYPE"
10G
By: emadnabil on Thu, 22 February 2024
2 1270 Thu, 22 February 2024 05:19
By: cookiemonster
  Query having multiple subqueries to be simplified
11g enterprise version
By: harishankar_kar on Tue, 20 February 2024
6 3210 Wed, 21 February 2024 04:34
By: cookiemonster
  BLOB Column with Zip File Convert to CLOB
Oracle, 19.0.0.0.0, Linux
By: Duane on Tue, 20 February 2024
2 1328 Tue, 20 February 2024 15:45
By: Duane
  Help needed in Tricky Group by
oracle 19c
By: born2achieve on Mon, 19 February 2024
2 1778 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 16270 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 8064 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 9063 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 7046 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 8297 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 44694 Wed, 07 February 2024 10:35
By: Amine
  oracle10g and utl_http
oracle10g
By: aabunarr on Sat, 03 February 2024
2 10611 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 13077 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 22067 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 17337 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 19822 Fri, 19 January 2024 11:04
By: Darth Waiter
  Need help to build a query
Oracle12C
By: shabir46 on Wed, 17 January 2024
1 13832 Wed, 17 January 2024 12:12
By: Michel Cadot
  XML Create logic
By: vips2988 on Wed, 10 January 2024
3 14955 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 11891 Tue, 09 January 2024 09:28
By: wtolentino
  plsql writen test questions
oracle 18
By: bammidi on Sun, 07 January 2024
4 13711 Mon, 08 January 2024 09:07
By: bammidi
  Partition
19c
By: babuknb on Thu, 07 December 2023
6 26163 Sun, 07 January 2024 12:26
By: babuknb
  Create Partition and Sub-Partition
By: ace_friends22 on Wed, 27 December 2023
8 24716 Wed, 27 December 2023 07:33
By: Solomon Yakobson
icon5.gif problem with sql passthru syntax - get "FROM keyword not found where expected (4 merged)
MS Access query passthru to Oracle
By: Bob Alston on Fri, 22 December 2023
7 40409 Tue, 26 December 2023 22:47
By: flyboy
  Condition based truncate partition
Oracle
By: ace_friends22 on Fri, 22 December 2023
2 21533 Fri, 22 December 2023 09:58
By: Solomon Yakobson
  Problem in pivot query
12.1.0.1
By: OraFerro on Fri, 15 December 2023
7 25444 Thu, 21 December 2023 12:19
By: Barbara Boehmer
  Help need in writing query to get JSON format output
Oracle 19c
By: pr76666 on Mon, 30 January 2023
10 34918 Thu, 14 December 2023 06:51
By: annabelle67
  Created schedule based on date conditions
12.1.0.1
By: OraFerro on Wed, 06 December 2023
8 18359 Tue, 12 December 2023 04:42
By: OraFerro
  sql Qurey
Oracle 10g
By: amjadem@gmail.com on Sat, 02 December 2023
5 13019 Sat, 02 December 2023 11:52
By: Solomon Yakobson
  Transform row data into columns
Oracle 19c, Linux
By: rajiv.oradev on Wed, 22 November 2023
20 19847 Wed, 29 November 2023 20:52
By: Solomon Yakobson
  Sequentially update a column with a decrementing value
By: madfeen on Fri, 24 November 2023
11 15520 Mon, 27 November 2023 02:23
By: madfeen
  SQL QUERY
11g
By: glmjoy on Sat, 25 November 2023
4 13987 Sat, 25 November 2023 05:12
By: glmjoy
  PL/SQL wrapper error
By: subratd on Tue, 06 March 2007
9 29991 Thu, 23 November 2023 03:42
By: NevemTeve
  Help with query returning JSON
Oracle, 19.0.0.0.0, Linux
By: Duane on Thu, 16 November 2023
7 13265 Thu, 16 November 2023 11:01
By: Duane
  Recursive subquery factoring
11.2.0.30
By: Amine on Mon, 06 November 2023
7 16186 Tue, 07 November 2023 14:30
By: mathguy
  Create a oracle function that parse a string to date time when not null
20.4.1.407
By: DorababuMeka on Mon, 30 October 2023
7 13088 Mon, 30 October 2023 08:09
By: Barbara Boehmer
  Unable to compile procedure
ORACLE
By: DorababuMeka on Thu, 26 October 2023
7 8665 Fri, 27 October 2023 05:44
By: Michel Cadot
  Need a pl/sql block to be entered in existing package
"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0"
By: indupriyav_2023 on Thu, 05 October 2023
3 22242 Thu, 05 October 2023 15:11
By: Barbara Boehmer
  Improve select with inner JOIN
Oracle 12, SQL, Linux
By: carlino70 on Thu, 28 September 2023
12 23107 Mon, 02 October 2023 13:20
By: carlino70
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: Fri Feb 23 17:13:14 CST 2024