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
  How to Inherit data default from %TYPE attribute for a variable
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
By: Andrey_R on Wed, 15 July 2020
7 1892 Wed, 15 July 2020 10:33
By: Michel Cadot
  REGEXP_LIKE to match string in a list
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 15 July 2020
2 1320 Wed, 15 July 2020 08:45
By: wtolentino
  issue in inserting pdf file in a table
oracle 12c, windows
By: form_user1 on Tue, 14 July 2020
10 1639 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 3976 Fri, 10 July 2020 15:33
By: EdStevens
  Run Time Errors 933 and 512 executing Proc
SQL Developer Version 17.3.2.341
By: cfairtp on Thu, 09 July 2020
9 4672 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 2972 Wed, 08 July 2020 16:23
By: bluetooth420
  Identify the format and display the data type of a string
Oracle DB 11g
By: adfnewbie on Tue, 07 July 2020
12 2963 Tue, 07 July 2020 11:10
By: Michel Cadot
  To store table row count in the same table's comment
any version Oracle
By: Olexandr Siroklyn on Fri, 03 July 2020
4 4365 Mon, 06 July 2020 09:49
By: Olexandr Siroklyn
icon5.gif Newbie needs help with wm_concat
Oracle Database 10g Release 10.2.0.5.0 - Production; PL/SQL Release 10.2.0.5.0 - Production; "CORE 10.2.0.5.0 Production"; TNS for Linux: Version 10.2.0.5.0 - Production; NLSRTL Version 10.2
By: Operator101 on Tue, 30 June 2020
6 3009 Mon, 06 July 2020 05:51
By: Operator101
  DB link issue in cloned databases on same host
11.1.0.7.0
By: aloksk on Tue, 28 January 2020
8 5828 Fri, 03 July 2020 03:04
By: Sooqa
  Oracle query
Oracle 12c
By: srinivas.k2005 on Wed, 01 July 2020
12 5159 Fri, 03 July 2020 00:09
By: Michel Cadot
  Help with the minus operator
RDBMS 11.2.0.4
By: BeefStu on Wed, 01 July 2020
0 2740 Wed, 01 July 2020 05:50
By: BeefStu
  Extract substring equal to a 7 digits number (merged)
By: annacol on Wed, 17 June 2020
12 5801 Tue, 30 June 2020 17:40
By: annacol
  Can't connect with new user created
By: Mark70 on Tue, 30 June 2020
4 1853 Tue, 30 June 2020 07:46
By: EdStevens
  PLS-00801: internal error [*** ASSERT at file pdz2.c, line 4788; Illegal access (Text)
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production, TNS for Linux: Version 12.2.0.1.0 - Production
By: s4.ora on Tue, 30 June 2020
0 2212 Tue, 30 June 2020 03:34
By: s4.ora
  Problem with Sequence-Creation via Trigger
Oracle 12.1 on an ODA (Oracle Database Appliance)
By: YannVDC on Fri, 19 June 2020
10 5079 Mon, 29 June 2020 06:33
By: Bill B
  ORA-00904: : invalid identifier
RDBMS 11.2.0.4
By: BeefStu on Sat, 27 June 2020
4 3397 Mon, 29 June 2020 06:02
By: Bill B
  Want to trigger the URL using UTL_HTTP
12.1.0.2.0
By: kavikeerthana on Sat, 27 June 2020
6 3391 Sun, 28 June 2020 07:49
By: BlackSwan
  Creating a record from existing random records (5 merged)
RDBMS 11.2.0.4
By: BeefStu on Fri, 19 June 2020
24 8422 Fri, 26 June 2020 23:44
By: Michel Cadot
  ORA-00904: invalid identifier
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: s4.ora on Thu, 25 June 2020
1 1681 Thu, 25 June 2020 05:15
By: s4.ora
  View and Table created from same query giving different result
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: s4.ora on Tue, 09 June 2020
4 2855 Thu, 25 June 2020 05:06
By: s4.ora
  Loading a CLOB with a KEY
By: Mark70 on Mon, 22 June 2020
2 1588 Mon, 22 June 2020 09:53
By: Michel Cadot
  Date format with UTC
By: Mark70 on Thu, 18 June 2020
3 3128 Mon, 22 June 2020 07:18
By: Bill B
  2 Rows Data into 1 Row
By: Genesys on Thu, 18 June 2020
3 3004 Fri, 19 June 2020 06:00
By: Solomon Yakobson
  Query not returning correct values (merged)
Windows 10 Pro. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0, Forms 11g 32 bit
By: buggleboy007 on Tue, 16 June 2020
11 3207 Wed, 17 June 2020 07:12
By: EdStevens
  'Create table' statement is hanging
SQL*Plus: Release 11.2.0.3.0 Production
By: aidi-h on Mon, 15 June 2020
4 2747 Tue, 16 June 2020 12:44
By: Bill B
  get closer to datetime in two tables
oracle 12c
By: mape on Tue, 16 June 2020
3 2017 Tue, 16 June 2020 06:00
By: mape
  The ESCAPE Option
By: amirmg on Wed, 10 June 2020
7 3761 Fri, 12 June 2020 02:29
By: Michel Cadot
  Time Portion of Date/Time Value Being Stripped When Passed to Stored Procedure (3 merged)
By: bmccollum on Tue, 09 June 2020
7 3136 Thu, 11 June 2020 03:06
By: John Watson
  Multiple rows into on "TEMP" table?
By: RM33 on Fri, 29 May 2020
2 3320 Wed, 10 June 2020 13:50
By: Bill B
  Simple UPDATE - should be easy but just can't get it!
Oracle 18c - but should apply to any version!
By: dragam on Sun, 07 June 2020
6 2649 Wed, 10 June 2020 13:38
By: Bill B
  Creating a not well-formed XML
By: Mark70 on Wed, 10 June 2020
1 1354 Wed, 10 June 2020 05:25
By: Michel Cadot
  CASE Statement on a Cursor
R12
By: ajayhareesh on Mon, 08 June 2020
5 2286 Tue, 09 June 2020 07:39
By: Solomon Yakobson
  Commands in SQl
By: aartiyadav on Fri, 05 June 2020
4 3353 Mon, 08 June 2020 09:57
By: Michel Cadot
  FORALL with associative array and INDEX BY VARCHAR
xe 11g R2
By: hudo on Sat, 06 June 2020
3 2126 Sun, 07 June 2020 05:25
By: Michel Cadot
  Adding [CDATA[ element in an XML
By: Mark70 on Thu, 04 June 2020
2 2887 Fri, 05 June 2020 00:40
By: _jum
  How to use table functions
By: Mark70 on Wed, 03 June 2020
3 2238 Thu, 04 June 2020 09:30
By: EdStevens
  How to add SOAP elements to XML
Oracle 10g
By: Mark70 on Mon, 01 June 2020
3 1791 Wed, 03 June 2020 10:48
By: Michel Cadot
  BLOB msg print in xml format
Oracle 12c
By: bkbora on Tue, 02 June 2020
4 2125 Wed, 03 June 2020 01:26
By: Michel Cadot
  Split Comma seperated Value
By: vharish006 on Tue, 02 June 2020
1 1591 Wed, 03 June 2020 00:03
By: Michel Cadot
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 Sep 21 08:51:27 CDT 2020