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 find out Last Modification Time of a database?
Oracle 12c
By: muniraj_tomar on Mon, 17 July 2017
13 663 Wed, 26 July 2017 07:03
By: BlackSwan
  Insert statement with bind variable and Create statement
Oracle 10.1
By: jaggub on Fri, 14 July 2017
2 204 Fri, 14 July 2017 19:19
By: Barbara Boehmer
  Pivot columns and dynamically assign values based on column name
Oracle 12.1.0.2, Linux
By: sspn2010 on Thu, 13 July 2017
6 426 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 118 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 231 Wed, 12 July 2017 09:41
By: Deep Chakraborty
  uploading excel with transposed data
By: oracbeg on Wed, 12 July 2017
2 250 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 514 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 256 Tue, 11 July 2017 08:06
By: Solomon Yakobson
  Cast_to_number not working
By: purnima1 on Tue, 11 July 2017
4 220 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 174 Mon, 10 July 2017 12:39
By: joy_division
  Case statement in From Clause
By: ramya29p on Mon, 10 July 2017
7 379 Fri, 14 July 2017 19:33
By: Barbara Boehmer
  Regular Expressions
Oracle
By: oomjai2233 on Fri, 07 July 2017
14 379 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 234 Thu, 06 July 2017 12:16
By: Michel Cadot
  Search in concatenated string (merged)
By: patneel on Wed, 05 July 2017
2 196 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 504 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 558 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 152 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 682 Fri, 07 July 2017 11:15
By: Michel Cadot
  Functional based index
By: Bala_Y on Mon, 03 July 2017
17 549 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 213 Mon, 03 July 2017 07:01
By: BlackSwan
  Recursive select
Oracle 9i
By: banach600 on Mon, 03 July 2017
21 569 Wed, 05 July 2017 05:14
By: banach600
  Appending CLOB
Oracle 10g
By: chat2raj.s on Mon, 03 July 2017
24 648 Sun, 09 July 2017 06:03
By: Michel Cadot
  String manipulation
By: praf1981 on Mon, 10 July 2017
3 437 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 220 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 309 Fri, 30 June 2017 01:20
By: John Watson
  Extracting number
12c
By: m.abdulhaq on Tue, 27 June 2017
12 512 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 296 Wed, 28 June 2017 00:05
By: Gurubalan
  help needed with SQL code
Oracle, 11, windows
By: aadebayo on Fri, 23 June 2017
7 322 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 880 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 268 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 306 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 424 Thu, 29 June 2017 11:36
By: Manoj.Gupta.91
  Sending List to Oracle Stored Procedure
By: anandneema on Mon, 19 June 2017
3 372 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 393 Fri, 16 June 2017 10:39
By: BlackSwan
  Help the newbie to do my first procedure
By: TonyDu94 on Wed, 14 June 2017
8 363 Thu, 15 June 2017 00:26
By: flyboy
  grouping of records
Oracle 11.2.0.3
By: pointers on Sat, 17 June 2017
1 413 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 222 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 296 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 3774 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 320 Wed, 14 June 2017 13:54
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: Wed Sep 20 04:30:07 CDT 2017

Total time taken to generate the page: 0.08043 seconds