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
  Getting months in the current Fiscal Year in Oracle
Oracle Database 11g Enterprise Edition
By: megha2525 on Fri, 04 November 2016
5 437 Wed, 09 November 2016 03:01
By: Flyby
  Query help
Oracle
By: julien1630 on Tue, 08 November 2016
14 660 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 692 Tue, 08 November 2016 07:06
By: EdStevens
  Procedure execution issue and trace
11g r2, linux
By: qazims92 on Mon, 07 November 2016
7 468 Tue, 08 November 2016 03:56
By: cookiemonster
  conversion to 16bit decimal
oracle 11gr2
By: guddu_12 on Fri, 28 October 2016
16 606 Mon, 07 November 2016 10:09
By: guddu_12
  Conditional based default value
Oracle 11
By: saipradyumn on Mon, 07 November 2016
5 211 Mon, 07 November 2016 08:05
By: saipradyumn
  package modified details
oracle 12c, unix
By: pstanand on Sun, 06 November 2016
6 268 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 290 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 1069 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 337 Fri, 04 November 2016 11:04
By: Michel Cadot
  Query Help
Oracle 11g
By: SADASIVAM on Sat, 15 October 2016
14 779 Fri, 04 November 2016 04:03
By: SADASIVAM
  How to format JSON column
RDBMS 12C
By: samiraly on Mon, 31 October 2016
5 406 Thu, 03 November 2016 09:04
By: samiraly
  Column dropped
11 g
By: saipradyumn on Mon, 24 October 2016
3 453 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 724 Wed, 02 November 2016 06:08
By: Solomon Yakobson
  ORA-06502 with UTL_RAW
11gr2, Windows
By: qazims92 on Fri, 28 October 2016
12 606 Wed, 02 November 2016 02:29
By: qazims92
  Partition Removing
Oracle 11g
By: saipradyumn on Mon, 03 October 2016
8 613 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 615 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 714 Wed, 02 November 2016 01:08
By: SADASIVAM
  Table compression
Oracle 12c
By: srinivas.k2005 on Fri, 28 October 2016
15 619 Tue, 01 November 2016 15:28
By: John Watson
  low value & high value
Oracle 11g
By: saipradyumn on Thu, 27 October 2016
2 403 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 752 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 455 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 387 Thu, 27 October 2016 15:01
By: Solomon Yakobson
  Purging old records
11gR2 - Linux
By: grvenkatesh1986@gmail.com on Thu, 27 October 2016
6 414 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 771 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 428 Wed, 26 October 2016 10:13
By: Michel Cadot
  transaction id sql
By: suji6281 on Mon, 24 October 2016
4 699 Tue, 25 October 2016 23:54
By: Barbara Boehmer
  Referencing Collection elements
11g
By: Irish88 on Fri, 14 October 2016
6 959 Tue, 25 October 2016 06:45
By: Irish88
  worklist sql
By: suji6281 on Fri, 21 October 2016
3 986 Tue, 25 October 2016 05:07
By: suji6281
  error ORA 210001
By: yk107 on Mon, 24 October 2016
7 664 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 399 Mon, 24 October 2016 19:52
By: Barbara Boehmer
  need help in sql query
oracle 10g
By: harry13 on Mon, 24 October 2016
2 301 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 3170 Fri, 21 October 2016 01:36
By: John Watson
  multi insert
By: premier10 on Thu, 20 October 2016
14 550 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 440 Thu, 20 October 2016 04:18
By: cookiemonster
  sql query with combination of row values
By: gorants on Wed, 19 October 2016
5 433 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 626 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 357 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 412 Tue, 18 October 2016 08:12
By: Michel Cadot
  star keyword oracle
Oracle 11g
By: ram_orafaq1989 on Mon, 17 October 2016
3 320 Mon, 17 October 2016 15:06
By: EdStevens
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: Fri Mar 24 05:24:01 CDT 2017

Total time taken to generate the page: 0.17193 seconds