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
  API for Progress Line
By: GHDSSS on Fri, 24 July 2020
1 1146 Fri, 24 July 2020 10:25
By: Michel Cadot
  select with while
Oracle 12c
By: mape on Wed, 22 July 2020
4 1374 Wed, 22 July 2020 12:23
By: EdStevens
  ORA-00932: inconsistent datatypes: expected - got NCLOB
Oracle
By: vpavan2000 on Wed, 22 July 2020
1 1210 Wed, 22 July 2020 04:31
By: Michel Cadot
  XML over 64K
By: Mark70 on Tue, 21 July 2020
1 1027 Tue, 21 July 2020 09:57
By: Michel Cadot
icon5.gif ear multivalue json as rows
oracle 19
By: wjuteau on Mon, 20 July 2020
2 1292 Tue, 21 July 2020 01:54
By: wjuteau
  Sorting of columns in alternative order.
11g
By: pavansivaece@gmail.com on Sat, 18 July 2020
4 1258 Sat, 18 July 2020 15:18
By: Michel Cadot
  creating a materialized view throws "ORA-01031: insufficient privileges"
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 15 July 2020
5 2081 Wed, 15 July 2020 12:56
By: wtolentino
  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 1931 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 1338 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 1686 Wed, 15 July 2020 06:14
By: Michel Cadot
  insert rows
12c
By: DRDBA on Thu, 09 July 2020
4 4041 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 4722 Fri, 10 July 2020 07:03
By: cfairtp
  Running script present on webserver
10g
By: bluetooth420 on Wed, 08 July 2020
7 2997 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 3002 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 4392 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 3057 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 5896 Fri, 03 July 2020 03:04
By: Sooqa
  Oracle query
Oracle 12c
By: srinivas.k2005 on Wed, 01 July 2020
12 5205 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 2766 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 5868 Tue, 30 June 2020 17:40
By: annacol
  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 2241 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 5139 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 3441 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 3447 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 8535 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 1717 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 2901 Thu, 25 June 2020 05:06
By: s4.ora
  Loading a CLOB with a KEY
By: Mark70 on Mon, 22 June 2020
2 1617 Mon, 22 June 2020 09:53
By: Michel Cadot
  2 Rows Data into 1 Row
By: Genesys on Thu, 18 June 2020
3 3034 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 3265 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 2790 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 2034 Tue, 16 June 2020 06:00
By: mape
  The ESCAPE Option
By: amirmg on Wed, 10 June 2020
7 3827 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 3229 Thu, 11 June 2020 03:06
By: John Watson
  Multiple rows into on "TEMP" table?
By: RM33 on Fri, 29 May 2020
2 3347 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 2686 Wed, 10 June 2020 13:38
By: Bill B
  Creating a not well-formed XML
By: Mark70 on Wed, 10 June 2020
1 1377 Wed, 10 June 2020 05:25
By: Michel Cadot
  CASE Statement on a Cursor
R12
By: ajayhareesh on Mon, 08 June 2020
5 2369 Tue, 09 June 2020 07:39
By: Solomon Yakobson
  Commands in SQl
By: aartiyadav on Fri, 05 June 2020
4 3401 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 2191 Sun, 07 June 2020 05:25
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: Fri Sep 25 11:53:53 CDT 2020