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
  Query Help
Oracle Database 11g 11.2.0.4.0
By: SADASIVAM on Wed, 02 November 2016
0 805 Wed, 02 November 2016 01:08
By: SADASIVAM
  Table compression
Oracle 12c
By: srinivas.k2005 on Fri, 28 October 2016
15 719 Tue, 01 November 2016 15:28
By: John Watson
  low value & high value
Oracle 11g
By: saipradyumn on Thu, 27 October 2016
2 514 Tue, 01 November 2016 06:58
By: saipradyumn
  Materialized view creation with complex queries
11.2.0.4
By: grpatwari on Wed, 26 October 2016
12 855 Mon, 31 October 2016 04:18
By: grpatwari
  Bug in Oracle External Table Not display Decimal Values
Oracle11g, Unix
By: ninan on Thu, 27 October 2016
8 574 Fri, 28 October 2016 02:58
By: Michel Cadot
  Split Blog column to multiple columns within a row
By: alexust on Wed, 26 October 2016
4 465 Thu, 27 October 2016 15:01
By: Solomon Yakobson
  Purging old records
11gR2 - Linux
By: grvenkatesh1986@gmail.com on Thu, 27 October 2016
6 512 Thu, 27 October 2016 11:51
By: Michel Cadot
  Query : Need help on populating prev day data in current day if missing
Oracle 11.2
By: srinivas.k2005 on Tue, 25 October 2016
7 874 Wed, 26 October 2016 10:14
By: Michel Cadot
  NULL VS ''
Oracle 11g Release 2, Linux
By: anil_mk on Wed, 26 October 2016
4 541 Wed, 26 October 2016 10:13
By: Michel Cadot
  transaction id sql
By: suji6281 on Mon, 24 October 2016
4 892 Tue, 25 October 2016 23:54
By: Barbara Boehmer
  Referencing Collection elements
11g
By: Irish88 on Fri, 14 October 2016
6 1235 Tue, 25 October 2016 06:45
By: Irish88
  worklist sql
By: suji6281 on Fri, 21 October 2016
3 1134 Tue, 25 October 2016 05:07
By: suji6281
  error ORA 210001
By: yk107 on Mon, 24 October 2016
7 830 Tue, 25 October 2016 03:14
By: cookiemonster
  Can we update "last_update_date" on Closed\Cancelled Orders using API
Oracle R12
By: ajayhareesh on Mon, 24 October 2016
1 589 Mon, 24 October 2016 19:52
By: Barbara Boehmer
  need help in sql query
oracle 10g
By: harry13 on Mon, 24 October 2016
2 374 Mon, 24 October 2016 07:52
By: Michel Cadot
  calculate working days not beween date - merged ( 1 2)
By: shahzad-ul-hasan on Tue, 10 November 2015
79 3322 Fri, 21 October 2016 01:36
By: John Watson
  multi insert
By: premier10 on Thu, 20 October 2016
14 658 Thu, 20 October 2016 13:13
By: Bill B
  Interval in DBMS_JOB
11.2.0.4
By: azeem87 on Wed, 19 October 2016
2 520 Thu, 20 October 2016 04:18
By: cookiemonster
  sql query with combination of row values
By: gorants on Wed, 19 October 2016
5 497 Thu, 20 October 2016 03:09
By: pablolee
  PL/SQL Function fails without an exception
Oracle 12c
By: moverdear on Mon, 19 September 2016
11 700 Wed, 19 October 2016 09:54
By: BlackSwan
  Insert a space in the middle of a six characther string
Oracle 11g
By: halifaxns on Tue, 18 October 2016
2 420 Tue, 18 October 2016 11:09
By: halifaxns
  Help required for getting create index DDL on partitioned table.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 18 October 2016
8 476 Tue, 18 October 2016 08:12
By: Michel Cadot
  star keyword oracle
Oracle 11g
By: ram_orafaq1989 on Mon, 17 October 2016
3 381 Mon, 17 October 2016 15:06
By: EdStevens
  replace with question mark in the filename
oracle 11.2.0.3
By: pointers on Sat, 15 October 2016
2 523 Sat, 15 October 2016 06:12
By: pointers
  Confirming Custom Raised Error Exceptions
Oracle 11g
By: Irish88 on Fri, 07 October 2016
6 673 Fri, 14 October 2016 08:48
By: Irish88
  Update Statement Correction
By: suji6281 on Thu, 13 October 2016
3 416 Thu, 13 October 2016 11:35
By: Michel Cadot
  ORA-01843: not a valid month and ORA-01847: day of month must be between 1 and last day of month
11.2.0.4
By: azeem87 on Wed, 12 October 2016
10 703 Thu, 13 October 2016 10:51
By: Solomon Yakobson
icon5.gif How to generate Query aggregation in oracle
Oracle
By: rohansr002 on Wed, 12 October 2016
2 436 Thu, 13 October 2016 00:31
By: Michel Cadot
  pl/sql table
Oracle 12c
By: SamMen on Wed, 12 October 2016
4 390 Wed, 12 October 2016 13:01
By: John Watson
  Anonymous block in sql plus
By: SamMen on Tue, 11 October 2016
7 654 Wed, 12 October 2016 11:38
By: Bill B
  Create Table error
11g
By: Irish88 on Tue, 11 October 2016
3 528 Wed, 12 October 2016 07:24
By: Irish88
  Unable to Recreate the Procedure
Oracle 10g
By: chat2raj.s on Tue, 11 October 2016
7 439 Tue, 11 October 2016 08:57
By: chat2raj.s
  Easy Query
By: calamardo114 on Mon, 10 October 2016
8 582 Tue, 11 October 2016 03:41
By: cookiemonster
  What is Corrected By RowID? I wish to know Missing Numbers in a column
By: graphe on Tue, 11 October 2016
4 478 Tue, 11 October 2016 03:39
By: Littlefoot
  rows to column text
By: bchowdam on Fri, 07 October 2016
13 814 Mon, 10 October 2016 19:44
By: Barbara Boehmer
  compile invalid view
By: desmond30 on Mon, 10 October 2016
5 477 Mon, 10 October 2016 14:47
By: Michel Cadot
  If exists clause in oracle
By: mazeem on Sat, 08 October 2016
6 602 Sun, 09 October 2016 07:03
By: Solomon Yakobson
icon10.gif Declations unknown
SQL Developer 4.0.3.16
By: Donfox09 on Fri, 07 October 2016
6 535 Fri, 07 October 2016 21:34
By: Donfox09
  Displaying DESC_TAB parms
Oralce 11g
By: Irish88 on Mon, 03 October 2016
18 1045 Thu, 06 October 2016 13:15
By: Barbara Boehmer
  Count of Data in Each Subpartition
Oracle 11g
By: abhayman on Wed, 05 October 2016
9 567 Thu, 06 October 2016 13:15
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: Sun Jul 23 01:58:14 CDT 2017

Total time taken to generate the page: 0.07912 seconds