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
  Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement
Oracle 10g
By: keewee279 on Sun, 09 July 2017
1 1432 Sun, 09 July 2017 06:05
By: Michel Cadot
  Appending CLOB
Oracle 10g
By: chat2raj.s on Mon, 03 July 2017
24 7183 Sun, 09 July 2017 06:03
By: Michel Cadot
  Get last 200 records from table in oracle
11g
By: asliyanage on Tue, 04 July 2017
19 5739 Fri, 07 July 2017 11:15
By: Michel Cadot
  Regular Expressions
Oracle
By: oomjai2233 on Fri, 07 July 2017
14 5404 Fri, 07 July 2017 05:56
By: Michel Cadot
  Functional based index
By: Bala_Y on Mon, 03 July 2017
17 5539 Thu, 06 July 2017 16:58
By: Bala_Y
  Report hangs (possibly query related).. is this possible cause?
Oracle Reports 11g, Oracle 12c Database
By: nait1234 on Thu, 06 July 2017
8 2368 Thu, 06 July 2017 12:16
By: Michel Cadot
  Accessing Sub directory under Oracle directory
11g
By: harshadsp on Thu, 19 May 2016
12 8143 Thu, 06 July 2017 09:52
By: Bill B
  Search in concatenated string (merged)
By: patneel on Wed, 05 July 2017
2 1514 Wed, 05 July 2017 15:15
By: Michel Cadot
  Recursive select
Oracle 9i
By: banach600 on Mon, 03 July 2017
21 5736 Wed, 05 July 2017 05:14
By: banach600
  Extracting number
12c
By: m.abdulhaq on Tue, 27 June 2017
12 4065 Tue, 04 July 2017 01:06
By: bbob
  Moving data from one table to another
Oracle 11g
By: clancypc on Mon, 03 July 2017
1 1332 Mon, 03 July 2017 07:01
By: BlackSwan
  What is the error ora-20914 pre insert I am getting this error in the forms?
By: narendraenamala on Sat, 01 July 2017
3 1584 Sat, 01 July 2017 01:53
By: narendraenamala
  Materialized View refresh performance issue.
Oracle 11g R2
By: Manoj.Gupta.91 on Thu, 29 June 2017
3 1516 Fri, 30 June 2017 01:20
By: John Watson
  How to generate JSON
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Wed, 21 June 2017
4 3202 Thu, 29 June 2017 11:36
By: Manoj.Gupta.91
  ORA-01830 in XMLTABLE for DATE conversion
11g and 12c
By: hamsterbacke on Thu, 22 June 2017
17 8521 Wed, 28 June 2017 01:29
By: Michel Cadot
  not gettting output for showplanfrpspreadsheetcode11g
Oracle 12c, Solaris SPARC
By: Gurubalan on Mon, 26 June 2017
3 1685 Wed, 28 June 2017 00:05
By: Gurubalan
  help needed with SQL code
Oracle, 11, windows
By: aadebayo on Fri, 23 June 2017
7 6482 Fri, 23 June 2017 09:13
By: aadebayo
  PRMDB-0933-1
PRIMAVERA 16.2.1, WIN2K7 64BIT
By: hiper on Thu, 22 June 2017
1 1497 Thu, 22 June 2017 03:16
By: Michel Cadot
  how to calculate column value dynamically
oracle 11g 11.2.0.4.0 release
By: harishankar_kar on Wed, 21 June 2017
3 1894 Wed, 21 June 2017 08:25
By: Michel Cadot
  Sending List to Oracle Stored Procedure
By: anandneema on Mon, 19 June 2017
3 1870 Mon, 19 June 2017 09:45
By: Michel Cadot
  grouping of records
Oracle 11.2.0.3
By: pointers on Sat, 17 June 2017
1 1469 Sat, 17 June 2017 01:51
By: Michel Cadot
  stored proc execution based on selected value from a column
Oracle 11.2.0.4
By: veepee on Fri, 16 June 2017
5 1934 Fri, 16 June 2017 10:39
By: BlackSwan
  Oracle database link performance cum security issue
Oracle 10G R2
By: arpankumarmisra on Fri, 26 May 2017
9 4542 Thu, 15 June 2017 12:20
By: joy_division
  Locked object in gv$locked_object without transaction in gv$transaction
Oracle 11g r2 , Red Had RAC
By: Andrey_R on Sat, 27 May 2017
4 2635 Thu, 15 June 2017 10:25
By: Caffeine+
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 7214 Thu, 15 June 2017 00:26
By: flyboy
  [Error] Execution (64: 64): ORA-32034: unsupported use of WITH clause for materilized view
CORE 11.2.0.4.0 Production
By: JEWEL78 on Wed, 14 June 2017
7 4194 Wed, 14 June 2017 13:54
By: Bill B
  ORA-00922: missing or invalid option - PROCEDURE with SPOOL
By: freis_bcf on Tue, 06 June 2017
14 129400 Mon, 12 June 2017 03:02
By: cookiemonster
  Trigger to fill foreign key from another table
11.0.2.10
By: OraFerro on Sun, 11 June 2017
2 1333 Sun, 11 June 2017 03:40
By: Michel Cadot
  Update values "in groups"
Oracle 12c, 12.1.0.2.0, MS Windows 7
By: Littlefoot on Fri, 09 June 2017
5 1679 Fri, 09 June 2017 07:33
By: Solomon Yakobson
  Handling invalid identifier exception in plsql
oracle 11g
By: ynkr999 on Wed, 07 June 2017
6 19167 Fri, 09 June 2017 00:54
By: Michel Cadot
  Different result when using FOR UPDATE
Oracle 11
By: hundsmiachn on Tue, 06 June 2017
4 1935 Tue, 06 June 2017 09:56
By: Michel Cadot
  dbms_output.put_line for dynamic sql query
SQL*Plus: Release 11.2.0.3.0 Production
By: shawaj on Tue, 30 May 2017
4 3367 Sat, 03 June 2017 03:28
By: shawaj
  oracle external table issue
oracle 11g , pl/sql, sql
By: POGAKU_SANTHOSH on Wed, 31 May 2017
5 2851 Fri, 02 June 2017 19:03
By: Barbara Boehmer
  Sequence generation for Parallel Processing
ORACLE 11g, Windows
By: lokimisc on Fri, 12 May 2017
21 7331 Fri, 02 June 2017 15:08
By: Bill B
  Package to include a sleep inside a procedure
Linux 2.6.39-400.286.3.el6uek.x86_64 - Oracle 11.2.0.4.0
By: Nagesh1985 on Thu, 01 June 2017
9 3587 Fri, 02 June 2017 13:33
By: Bill B
  Passing value from one cursor to the other one.
By: AkilaSubramanian on Tue, 24 May 2011
6 84865 Fri, 02 June 2017 09:34
By: Bill B
  Creating foreign key constraints for nested tables of user defined types oracle
Oracle
By: Hatik on Thu, 01 June 2017
7 2923 Thu, 01 June 2017 22:35
By: Hatik
  Query Db table with Key Value
Oracle
By: hippylou2u on Fri, 26 May 2017
10 4326 Wed, 31 May 2017 11:11
By: Solomon Yakobson
  Armstrong numbers
By: sridhar.sangubhatla on Tue, 03 July 2007
12 13429 Tue, 30 May 2017 08:20
By: ynkr999
  Dependent Objects recursively
Oracle 11.2.0.3
By: pointers on Mon, 29 May 2017
4 1833 Tue, 30 May 2017 00:09
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: Sun Nov 17 18:05:14 CST 2019