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
  Pivot columns and dynamically assign values based on column name
Oracle 12.1.0.2, Linux
By: sspn2010 on Thu, 13 July 2017
6 407 Sun, 16 July 2017 21:18
By: sspn2010
  Re: PL/SQL:How to use VARRAY in the USING clause of EXECUTE IMMEDIATE? split from http://www.orafaq.com/forum/t/161791/
By: moracles on Tue, 11 July 2017
5 102 Tue, 11 July 2017 15:45
By: moracles
  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 199 Wed, 12 July 2017 09:41
By: Deep Chakraborty
  uploading excel with transposed data
By: oracbeg on Wed, 12 July 2017
2 224 Wed, 12 July 2017 07:38
By: Bill B
  Count Distinct Not Working in Case Select Oracle SQL
By: phaenggi on Tue, 11 July 2017
11 375 Wed, 12 July 2017 15:05
By: Bill B
  How to retrieve negative value as positive in simple brackets?
11gR2, Windows 10
By: oracbeg on Tue, 11 July 2017
5 237 Tue, 11 July 2017 08:06
By: Solomon Yakobson
  Cast_to_number not working
By: purnima1 on Tue, 11 July 2017
4 187 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 156 Mon, 10 July 2017 12:39
By: joy_division
  Case statement in From Clause
By: ramya29p on Mon, 10 July 2017
7 360 Fri, 14 July 2017 19:33
By: Barbara Boehmer
  Regular Expressions
Oracle
By: oomjai2233 on Fri, 07 July 2017
14 354 Fri, 07 July 2017 05:56
By: Michel Cadot
  Report hangs (possibly query related).. is this possible cause?
Oracle Reports 11g, Oracle 12c Database
By: nait1234 on Thu, 06 July 2017
8 215 Thu, 06 July 2017 12:16
By: Michel Cadot
  Search in concatenated string (merged)
By: patneel on Wed, 05 July 2017
2 181 Wed, 05 July 2017 15:15
By: Michel Cadot
  PLS-00201: identifier 'UTL_MAIL' must be declared
11.2.0.4
By: grpatwari on Wed, 05 July 2017
5 432 Wed, 26 July 2017 08:32
By: Bill B
  Code Help: Inserting Records based on records in another table meeting certain parameters
Oracle SQL Developer
By: cem616 on Wed, 09 August 2017
6 542 Mon, 14 August 2017 14:07
By: buggleboy007
  Error ORA-01722: Invalid use of Number in Select with Xmlagg / Xmlelement
Oracle 10g
By: keewee279 on Sun, 09 July 2017
1 130 Sun, 09 July 2017 06:05
By: Michel Cadot
  Get last 200 records from table in oracle
11g
By: asliyanage on Tue, 04 July 2017
19 639 Fri, 07 July 2017 11:15
By: Michel Cadot
  Functional based index
By: Bala_Y on Mon, 03 July 2017
17 512 Thu, 06 July 2017 16:58
By: Bala_Y
  Moving data from one table to another
Oracle 11g
By: clancypc on Mon, 03 July 2017
1 196 Mon, 03 July 2017 07:01
By: BlackSwan
  Recursive select
Oracle 9i
By: banach600 on Mon, 03 July 2017
21 535 Wed, 05 July 2017 05:14
By: banach600
  Appending CLOB
Oracle 10g
By: chat2raj.s on Mon, 03 July 2017
24 608 Sun, 09 July 2017 06:03
By: Michel Cadot
  String manipulation
By: praf1981 on Mon, 10 July 2017
3 411 Thu, 27 July 2017 05:57
By: praf1981
  What is the error ora-20914 pre insert I am getting this error in the forms?
By: narendraenamala on Sat, 01 July 2017
3 197 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 286 Fri, 30 June 2017 01:20
By: John Watson
  Extracting number
12c
By: m.abdulhaq on Tue, 27 June 2017
12 486 Tue, 04 July 2017 01:06
By: bbob
  not gettting output for showplanfrpspreadsheetcode11g
Oracle 12c, Solaris SPARC
By: Gurubalan on Mon, 26 June 2017
3 273 Wed, 28 June 2017 00:05
By: Gurubalan
  help needed with SQL code
Oracle, 11, windows
By: aadebayo on Fri, 23 June 2017
7 298 Fri, 23 June 2017 09:13
By: aadebayo
  ORA-01830 in XMLTABLE for DATE conversion
11g and 12c
By: hamsterbacke on Thu, 22 June 2017
17 821 Wed, 28 June 2017 01:29
By: Michel Cadot
  PRMDB-0933-1
PRIMAVERA 16.2.1, WIN2K7 64BIT
By: hiper on Thu, 22 June 2017
1 232 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 279 Wed, 21 June 2017 08:25
By: Michel Cadot
  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 394 Thu, 29 June 2017 11:36
By: Manoj.Gupta.91
  Sending List to Oracle Stored Procedure
By: anandneema on Mon, 19 June 2017
3 353 Mon, 19 June 2017 09:45
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 372 Fri, 16 June 2017 10:39
By: BlackSwan
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 341 Thu, 15 June 2017 00:26
By: flyboy
  grouping of records
Oracle 11.2.0.3
By: pointers on Sat, 17 June 2017
1 391 Sat, 17 June 2017 01:51
By: Michel Cadot
  Trigger to fill foreign key from another table
11.0.2.10
By: OraFerro on Sun, 11 June 2017
2 203 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 275 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 2752 Fri, 09 June 2017 00:54
By: Michel Cadot
  [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 290 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 17900 Mon, 12 June 2017 03:02
By: cookiemonster
  Different result when using FOR UPDATE
Oracle 11
By: hundsmiachn on Tue, 06 June 2017
4 236 Tue, 06 June 2017 09:56
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: Tue Aug 22 02:31:51 CDT 2017

Total time taken to generate the page: 0.02857 seconds