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
  Adding [CDATA[ element in an XML
By: Mark70 on Thu, 04 June 2020
2 2927 Fri, 05 June 2020 00:40
By: _jum
  BLOB msg print in xml format
Oracle 12c
By: bkbora on Tue, 02 June 2020
4 2149 Wed, 03 June 2020 01:26
By: Michel Cadot
  Split Comma seperated Value
By: vharish006 on Tue, 02 June 2020
1 1626 Wed, 03 June 2020 00:03
By: Michel Cadot
  Error ORA-00932 when viewing data from an OLAP cube
By: Edo97 on Tue, 02 June 2020
0 2125 Tue, 02 June 2020 03:42
By: Edo97
  count per group
web intelligence
By: jtylerrand on Sun, 31 May 2020
8 2474 Mon, 01 June 2020 11:17
By: Solomon Yakobson
  ORA-06530: Reference to uninitialized composite
By: sudheer45v on Sat, 30 May 2020
12 3272 Sun, 31 May 2020 05:57
By: sudheer45v
  Username length limitation in Oracle
By: uicmxz on Fri, 16 November 2007
6 25929 Sat, 30 May 2020 06:47
By: Bill B
  Dynamic Query into Cursor
Oracle 12c, Unix
By: Rayam69 on Fri, 29 May 2020
1 2736 Sat, 30 May 2020 00:35
By: Michel Cadot
  oracle -rearrange columns values based on value type
12.1.0.2
By: ghostman on Fri, 15 May 2020
11 3743 Thu, 28 May 2020 11:48
By: Bill B
  how to display the values with prefix increment?
Oracle
By: ramanajak on Thu, 28 May 2020
3 1296 Thu, 28 May 2020 09:24
By: Michel Cadot
  UTL_MAIL vs UTL_SMTP sending CLOB body
11.2.0.1.0
By: OraFerro on Wed, 13 May 2020
13 2878 Wed, 27 May 2020 16:53
By: Bill B
  Audit Database Problem
By: nisauaz on Wed, 27 May 2020
1 1428 Wed, 27 May 2020 12:24
By: Michel Cadot
  materialized view issue
oracle 11.2.0.3
By: irashu2001@gmail.com on Tue, 19 May 2020
7 2738 Wed, 27 May 2020 07:08
By: Bill B
  Return names of bind variables
Version 9.0.4.1644 01.75108 Windows (64-bit) 6.2 Build 9200
By: nbs on Sat, 23 May 2020
6 3540 Tue, 26 May 2020 02:50
By: nbs
  Missing number in series of numbers
Oracle 11g, windows
By: Vijay55 on Wed, 18 May 2016
6 4782 Mon, 25 May 2020 07:19
By: Solomon Yakobson
  key with different values
By: desmond30 on Sat, 23 May 2020
3 2412 Sun, 24 May 2020 06:22
By: Solomon Yakobson
icon5.gif Using associated array as SP parameter
12.2
By: thegerman on Thu, 21 May 2020
6 2079 Fri, 22 May 2020 06:30
By: Solomon Yakobson
  JSON Column for A Single Element with Potentially Multiple Values?
Oracle 19c
By: bmccollum on Thu, 21 May 2020
1 1134 Thu, 21 May 2020 17:33
By: Solomon Yakobson
  The cost of FILTER operations
DB 19.x
By: John Watson on Thu, 21 May 2020
1 1090 Thu, 21 May 2020 05:46
By: Michel Cadot
  driving_site hint
DB12.x
By: John Watson on Tue, 19 May 2020
20 2102 Wed, 20 May 2020 15:53
By: Lalit Kumar B
  ORA-21561: OID generation failed !!
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Redhat 6
By: fixxxer on Wed, 07 March 2018
12 12282 Wed, 20 May 2020 08:06
By: fixxxer
  Using SELECT to display various totals
12.2.0.2
By: johnw66 on Mon, 18 May 2020
4 1040 Tue, 19 May 2020 00:08
By: Michel Cadot
  Transposing data in single row
Oracle 12 c
By: OracleDBA_beginner on Fri, 15 May 2020
11 2285 Mon, 18 May 2020 04:58
By: Lalit Kumar B
  Procedure creation help
By: chavva.kiru@gmail.com on Wed, 13 May 2020
8 1379 Thu, 14 May 2020 10:55
By: Michel Cadot
  Creation of new partitions by increasing the sequence number
oracle 12C
By: chavva.kiru@gmail.com on Wed, 13 May 2020
5 1159 Wed, 13 May 2020 23:32
By: chavva.kiru@gmail.com
  Stored Procedure - not able to display no data found message
By: subash_141 on Wed, 13 May 2020
2 813 Wed, 13 May 2020 07:13
By: Solomon Yakobson
  Displaying select results in double columns
11.2.0.1.0
By: OraFerro on Sat, 09 May 2020
25 3780 Tue, 12 May 2020 08:17
By: Michel Cadot
  Date Column
By: deepakdot on Wed, 06 May 2020
25 3705 Sat, 09 May 2020 13:31
By: Michel Cadot
  Configuring Scripts
Windows 7
By: Premananda on Sun, 26 April 2020
6 2126 Sat, 09 May 2020 12:33
By: EdStevens
  Looping Chain of Synonyms
Oracle Database 12
By: mushy.khan1985 on Wed, 06 May 2020
14 1776 Wed, 06 May 2020 14:21
By: mushy.khan1985
  Query needs to be tune
12.2.0.2
By: bha_96 on Wed, 06 May 2020
4 1478 Wed, 06 May 2020 12:21
By: Michel Cadot
  Limit error on function
PL/SQL
By: ram43 on Mon, 04 May 2020
3 1584 Tue, 05 May 2020 01:24
By: _jum
  PL/SQL problem
Oracle SQL developer
By: nedislav on Fri, 01 May 2020
11 2459 Fri, 01 May 2020 12:29
By: EdStevens
  drithsx
By: glyph on Fri, 01 May 2020
2 1639 Fri, 01 May 2020 08:19
By: Michel Cadot
  ORA-04042 issue when trying to grant the access
Oracle
By: raghuguru on Mon, 27 April 2020
11 2467 Wed, 29 April 2020 08:02
By: EdStevens
  "ORA-00942: table or view does not exist" when creating view via role's privilege
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Thu, 23 April 2020
5 2858 Tue, 28 April 2020 14:28
By: wtolentino
  Query
12.0.2
By: bha_96 on Sat, 25 April 2020
22 3405 Mon, 27 April 2020 03:16
By: Michel Cadot
  How too convert rows into columns based on order hiredate month wise
oracle 12c
By: narendraenamala on Fri, 24 April 2020
1 2087 Fri, 24 April 2020 00:57
By: Michel Cadot
  Need age difference between warning and critical
Oracle
By: soubalaji on Wed, 22 April 2020
9 1355 Wed, 22 April 2020 12:10
By: Michel Cadot
  Duplicate returns from list of Values
Oracle APEX
By: WillJ on Fri, 17 April 2020
20 3113 Wed, 22 April 2020 10:26
By: WillJ
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 Sep 25 12:54:18 CDT 2020