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
  Update Table Based On Another Table
oracle 11g, windows server
By: morissa on Fri, 18 November 2016
14 4953 Tue, 22 November 2016 03:38
By: cookiemonster
  Show all months between 2 months in a group by query
Oracle 11g
By: avni on Mon, 21 November 2016
1 726 Mon, 21 November 2016 03:09
By: Michel Cadot
  Rows not populating
Oracle DB 12c
By: krishna.orcl97 on Fri, 18 November 2016
9 756 Fri, 18 November 2016 14:18
By: BlackSwan
  Oracle 11g Ntile function on top of Dense_rank
By: raj85844 on Wed, 16 November 2016
1 483 Wed, 16 November 2016 23:36
By: raj85844
  how to close open cursor when exception
oracle 11
By: yk107 on Tue, 15 November 2016
11 1217 Wed, 16 November 2016 12:57
By: yk107
  Calling procedure from trigger
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Windows 7
By: SW26477 on Wed, 16 November 2016
2 603 Wed, 16 November 2016 10:32
By: Michel Cadot
  merge statement problem
10g
By: emadnabil on Sun, 13 November 2016
15 1080 Mon, 14 November 2016 07:56
By: emadnabil
  Filling a table of object in function loop
11.0.2.10
By: OraFerro on Sun, 13 November 2016
7 846 Mon, 14 November 2016 06:31
By: Michel Cadot
  Need to match combination string at database
Oracle 11g, AIX server
By: Shan.kumar on Thu, 10 November 2016
12 7904 Mon, 14 November 2016 00:21
By: Shan.kumar
icon9.gif PL/SQL Email
Oracle 11gr2
By: VariableReset on Sat, 12 November 2016
3 788 Sat, 12 November 2016 06:48
By: VariableReset
  SQL Query Request
oracle 11g
By: raj85844 on Wed, 09 November 2016
14 1081 Fri, 11 November 2016 10:19
By: Michel Cadot
  spool sql data in excel multi sheets
By: Preeti123456 on Thu, 10 November 2016
3 793 Fri, 11 November 2016 04:17
By: pablolee
  How to log what parameter the API is passing to query
oracle 11g
By: magnify on Wed, 09 November 2016
3 349 Wed, 09 November 2016 12:22
By: BlackSwan
  Search data between months
Oracle 11g
By: Xandot on Wed, 09 November 2016
2 444 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 692 Wed, 09 November 2016 03:01
By: Flyby
  Query help
Oracle
By: julien1630 on Tue, 08 November 2016
14 7256 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 1001 Tue, 08 November 2016 07:06
By: EdStevens
  Procedure execution issue and trace
11g r2, linux
By: qazims92 on Mon, 07 November 2016
7 672 Tue, 08 November 2016 03:56
By: cookiemonster
  conversion to 16bit decimal
oracle 11gr2
By: guddu_12 on Fri, 28 October 2016
16 1036 Mon, 07 November 2016 10:09
By: guddu_12
  Conditional based default value
Oracle 11
By: saipradyumn on Mon, 07 November 2016
5 422 Mon, 07 November 2016 08:05
By: saipradyumn
  package modified details
oracle 12c, unix
By: pstanand on Sun, 06 November 2016
6 463 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 432 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 1781 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 570 Fri, 04 November 2016 11:04
By: Michel Cadot
  Query Help
Oracle 11g
By: SADASIVAM on Sat, 15 October 2016
14 1025 Fri, 04 November 2016 04:03
By: SADASIVAM
  How to format JSON column
RDBMS 12C
By: samiraly on Mon, 31 October 2016
5 713 Thu, 03 November 2016 09:04
By: samiraly
  Column dropped
11 g
By: saipradyumn on Mon, 24 October 2016
3 662 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 989 Wed, 02 November 2016 06:08
By: Solomon Yakobson
  ORA-06502 with UTL_RAW
11gr2, Windows
By: qazims92 on Fri, 28 October 2016
12 990 Wed, 02 November 2016 02:29
By: qazims92
  Partition Removing
Oracle 11g
By: saipradyumn on Mon, 03 October 2016
8 886 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 859 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 966 Wed, 02 November 2016 01:08
By: SADASIVAM
  Table compression
Oracle 12c
By: srinivas.k2005 on Fri, 28 October 2016
15 933 Tue, 01 November 2016 15:28
By: John Watson
  low value & high value
Oracle 11g
By: saipradyumn on Thu, 27 October 2016
2 671 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 1057 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 849 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 614 Thu, 27 October 2016 15:01
By: Solomon Yakobson
  Purging old records
11gR2 - Linux
By: grvenkatesh1986@gmail.com on Thu, 27 October 2016
6 678 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 1049 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 680 Wed, 26 October 2016 10:13
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 Jan 16 07:58:51 CST 2018

Total time taken to generate the page: 0.07441 seconds