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
  Merging of Interval Partitions
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Wed, 12 July 2017
3 1536 Wed, 12 July 2017 09:41
By: Deep Chakraborty
  uploading excel with transposed data
By: oracbeg on Wed, 12 July 2017
2 1179 Wed, 12 July 2017 07:38
By: Bill B
  How to retrieve negative value as positive in simple brackets?
11gR2, Windows 10
By: oracbeg on Tue, 11 July 2017
5 1377 Tue, 11 July 2017 08:06
By: Solomon Yakobson
  Cast_to_number not working
By: purnima1 on Tue, 11 July 2017
4 1340 Tue, 11 July 2017 02:00
By: purnima1
  Update Match Flag Status in Invoice Distribution
Oracle Applications : 11.5.10.2
By: iamaelle on Mon, 10 July 2017
1 956 Mon, 10 July 2017 12:39
By: joy_division
  GMT Time Stamp
PL SQL
By: OldDog on Sun, 28 May 2017
17 4193 Mon, 10 July 2017 12:08
By: Michel Cadot
  Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement
Oracle 10g
By: keewee279 on Sun, 09 July 2017
1 1060 Sun, 09 July 2017 06:05
By: Michel Cadot
  Appending CLOB
Oracle 10g
By: chat2raj.s on Mon, 03 July 2017
24 4919 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 4018 Fri, 07 July 2017 11:15
By: Michel Cadot
  Regular Expressions
Oracle
By: oomjai2233 on Fri, 07 July 2017
14 3650 Fri, 07 July 2017 05:56
By: Michel Cadot
  Functional based index
By: Bala_Y on Mon, 03 July 2017
17 3860 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 1619 Thu, 06 July 2017 12:16
By: Michel Cadot
  Accessing Sub directory under Oracle directory
11g
By: harshadsp on Thu, 19 May 2016
12 6167 Thu, 06 July 2017 09:52
By: Bill B
  Search in concatenated string (merged)
By: patneel on Wed, 05 July 2017
2 1153 Wed, 05 July 2017 15:15
By: Michel Cadot
  Recursive select
Oracle 9i
By: banach600 on Mon, 03 July 2017
21 3997 Wed, 05 July 2017 05:14
By: banach600
  Extracting number
12c
By: m.abdulhaq on Tue, 27 June 2017
12 2976 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 1035 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 1173 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 1229 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 2168 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 5815 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 1300 Wed, 28 June 2017 00:05
By: Gurubalan
  help needed with SQL code
Oracle, 11, windows
By: aadebayo on Fri, 23 June 2017
7 6024 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 1201 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 1367 Wed, 21 June 2017 08:25
By: Michel Cadot
  Sending List to Oracle Stored Procedure
By: anandneema on Mon, 19 June 2017
3 1399 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 1212 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 1504 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 3446 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 1995 Thu, 15 June 2017 10:25
By: Caffeine+
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 6514 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 3136 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 111930 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 1058 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 1283 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 16234 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 1370 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 2101 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 2081 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 5152 Fri, 02 June 2017 15:08
By: Bill B
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 Mar 25 08:41:45 CDT 2019