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
  Search data between months
Oracle 11g
By: Xandot on Wed, 09 November 2016
2 301 Wed, 09 November 2016 05:07
By: Xandot
  Getting months in the current Fiscal Year in Oracle
Oracle Database 11g Enterprise Edition
By: megha2525 on Fri, 04 November 2016
5 481 Wed, 09 November 2016 03:01
By: Flyby
  Query help
Oracle
By: julien1630 on Tue, 08 November 2016
14 731 Tue, 08 November 2016 10:36
By: Solomon Yakobson
  external table with single column
oracle 11g
By: guddu_12 on Mon, 07 November 2016
23 751 Tue, 08 November 2016 07:06
By: EdStevens
  Procedure execution issue and trace
11g r2, linux
By: qazims92 on Mon, 07 November 2016
7 511 Tue, 08 November 2016 03:56
By: cookiemonster
  conversion to 16bit decimal
oracle 11gr2
By: guddu_12 on Fri, 28 October 2016
16 714 Mon, 07 November 2016 10:09
By: guddu_12
  Conditional based default value
Oracle 11
By: saipradyumn on Mon, 07 November 2016
5 261 Mon, 07 November 2016 08:05
By: saipradyumn
  package modified details
oracle 12c, unix
By: pstanand on Sun, 06 November 2016
6 303 Sun, 06 November 2016 02:27
By: Michel Cadot
  query needed without using only where clause
10g
By: god_bunu on Fri, 04 November 2016
3 321 Sat, 05 November 2016 02:00
By: Michel Cadot
  Selecting the columns
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: saipradyumn on Tue, 06 September 2016
32 1226 Fri, 04 November 2016 11:24
By: Solomon Yakobson
  summation of multiple values for a particular at specific period
oracle 10.g
By: eogyamfi on Thu, 03 November 2016
10 386 Fri, 04 November 2016 11:04
By: Michel Cadot
  Query Help
Oracle 11g
By: SADASIVAM on Sat, 15 October 2016
14 823 Fri, 04 November 2016 04:03
By: SADASIVAM
  How to format JSON column
RDBMS 12C
By: samiraly on Mon, 31 October 2016
5 483 Thu, 03 November 2016 09:04
By: samiraly
  Column dropped
11 g
By: saipradyumn on Mon, 24 October 2016
3 499 Wed, 02 November 2016 14:59
By: Bill B
  Default Character type of the column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 01 October 2016
6 782 Wed, 02 November 2016 06:08
By: Solomon Yakobson
  ORA-06502 with UTL_RAW
11gr2, Windows
By: qazims92 on Fri, 28 October 2016
12 673 Wed, 02 November 2016 02:29
By: qazims92
  Partition Removing
Oracle 11g
By: saipradyumn on Mon, 03 October 2016
8 665 Wed, 02 November 2016 01:21
By: saipradyumn
  Query Help
Oracle Database 11g 11.2.0.4.0
By: SADASIVAM on Thu, 27 October 2016
4 663 Wed, 02 November 2016 01:11
By: SADASIVAM
  Query Help
Oracle Database 11g 11.2.0.4.0
By: SADASIVAM on Wed, 02 November 2016
0 776 Wed, 02 November 2016 01:08
By: SADASIVAM
  Table compression
Oracle 12c
By: srinivas.k2005 on Fri, 28 October 2016
15 671 Tue, 01 November 2016 15:28
By: John Watson
  low value & high value
Oracle 11g
By: saipradyumn on Thu, 27 October 2016
2 469 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 806 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 511 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 429 Thu, 27 October 2016 15:01
By: Solomon Yakobson
  Purging old records
11gR2 - Linux
By: grvenkatesh1986@gmail.com on Thu, 27 October 2016
6 467 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 830 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 473 Wed, 26 October 2016 10:13
By: Michel Cadot
  transaction id sql
By: suji6281 on Mon, 24 October 2016
4 791 Tue, 25 October 2016 23:54
By: Barbara Boehmer
  Referencing Collection elements
11g
By: Irish88 on Fri, 14 October 2016
6 1056 Tue, 25 October 2016 06:45
By: Irish88
  worklist sql
By: suji6281 on Fri, 21 October 2016
3 1072 Tue, 25 October 2016 05:07
By: suji6281
  error ORA 210001
By: yk107 on Mon, 24 October 2016
7 724 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 518 Mon, 24 October 2016 19:52
By: Barbara Boehmer
  need help in sql query
oracle 10g
By: harry13 on Mon, 24 October 2016
2 337 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 3223 Fri, 21 October 2016 01:36
By: John Watson
  multi insert
By: premier10 on Thu, 20 October 2016
14 594 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 483 Thu, 20 October 2016 04:18
By: cookiemonster
  sql query with combination of row values
By: gorants on Wed, 19 October 2016
5 473 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 665 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 396 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 447 Tue, 18 October 2016 08:12
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: Mon May 29 22:06:16 CDT 2017

Total time taken to generate the page: 0.24071 seconds