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
  complex query
oracle
By: bikashp on Wed, 23 November 2016
1 491 Wed, 23 November 2016 06:35
By: Michel Cadot
  Oracle Outer join Operator(+) with operand of OR or IN
Oracle, 11g, Windows 7
By: azamkhan on Mon, 23 January 2017
1 323 Mon, 23 January 2017 00:22
By: Michel Cadot
  Element exists in a collection
Oracle 11.2.0.3
By: pointers on Fri, 02 December 2016
3 716 Fri, 02 December 2016 06:43
By: Solomon Yakobson
  Trigger to prevent delete according to select
11.0.2.10
By: OraFerro on Tue, 22 November 2016
9 913 Thu, 24 November 2016 08:16
By: ALEXWE
  Show all months between 2 months in a group by query
Oracle 11g
By: avni on Mon, 21 November 2016
1 656 Mon, 21 November 2016 03:09
By: Michel Cadot
  Please provide best approach to design ETL in Oracle.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 24 November 2016
4 451 Thu, 24 November 2016 07:20
By: John Watson
  Correct order of data in Hierarchical Query
Oracle 12c
By: ramjss on Sat, 19 November 2016
13 1250 Tue, 06 December 2016 04:29
By: ramjss
  electronic data sharding
By: sudeepto chattaraj on Fri, 18 November 2016
14 1118 Tue, 22 November 2016 07:26
By: EdStevens
  Update Table Based On Another Table
oracle 11g, windows server
By: morissa on Fri, 18 November 2016
14 4577 Tue, 22 November 2016 03:38
By: cookiemonster
  Rows not populating
Oracle DB 12c
By: krishna.orcl97 on Fri, 18 November 2016
9 674 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 401 Wed, 16 November 2016 23:36
By: raj85844
  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 534 Wed, 16 November 2016 10:32
By: Michel Cadot
icon9.gif PL/SQL Email
Oracle 11gr2
By: VariableReset on Sat, 12 November 2016
3 714 Sat, 12 November 2016 06:48
By: VariableReset
  spool sql data in excel multi sheets
By: Preeti123456 on Thu, 10 November 2016
3 720 Fri, 11 November 2016 04:17
By: pablolee
  Need to match combination string at database
Oracle 11g, AIX server
By: Shan.kumar on Thu, 10 November 2016
12 7176 Mon, 14 November 2016 00:21
By: Shan.kumar
  How to log what parameter the API is passing to query
oracle 11g
By: magnify on Wed, 09 November 2016
3 301 Wed, 09 November 2016 12:22
By: BlackSwan
  SQL Query Request
oracle 11g
By: raj85844 on Wed, 09 November 2016
14 975 Fri, 11 November 2016 10:19
By: Michel Cadot
  Search data between months
Oracle 11g
By: Xandot on Wed, 09 November 2016
2 396 Wed, 09 November 2016 05:07
By: Xandot
  Query help
Oracle
By: julien1630 on Tue, 08 November 2016
14 6588 Tue, 08 November 2016 10:36
By: Solomon Yakobson
  merge statement problem
10g
By: emadnabil on Sun, 13 November 2016
15 981 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 763 Mon, 14 November 2016 06:31
By: Michel Cadot
  external table with single column
oracle 11g
By: guddu_12 on Mon, 07 November 2016
23 886 Tue, 08 November 2016 07:06
By: EdStevens
  Procedure execution issue and trace
11g r2, linux
By: qazims92 on Mon, 07 November 2016
7 601 Tue, 08 November 2016 03:56
By: cookiemonster
  Conditional based default value
Oracle 11
By: saipradyumn on Mon, 07 November 2016
5 346 Mon, 07 November 2016 08:05
By: saipradyumn
  how to close open cursor when exception
oracle 11
By: yk107 on Tue, 15 November 2016
11 1106 Wed, 16 November 2016 12:57
By: yk107
  package modified details
oracle 12c, unix
By: pstanand on Sun, 06 November 2016
6 390 Sun, 06 November 2016 02:27
By: Michel Cadot
  Getting months in the current Fiscal Year in Oracle
Oracle Database 11g Enterprise Edition
By: megha2525 on Fri, 04 November 2016
5 592 Wed, 09 November 2016 03:01
By: Flyby
  summation of multiple values for a particular at specific period
oracle 10.g
By: eogyamfi on Thu, 03 November 2016
10 492 Fri, 04 November 2016 11:04
By: Michel Cadot
  How to format JSON column
RDBMS 12C
By: samiraly on Mon, 31 October 2016
5 616 Thu, 03 November 2016 09:04
By: samiraly
  conversion to 16bit decimal
oracle 11gr2
By: guddu_12 on Fri, 28 October 2016
16 904 Mon, 07 November 2016 10:09
By: guddu_12
  ORA-06502 with UTL_RAW
11gr2, Windows
By: qazims92 on Fri, 28 October 2016
12 840 Wed, 02 November 2016 02:29
By: qazims92
  Bug in Oracle External Table Not display Decimal Values
Oracle11g, Unix
By: ninan on Thu, 27 October 2016
8 691 Fri, 28 October 2016 02:58
By: Michel Cadot
  Purging old records
11gR2 - Linux
By: grvenkatesh1986@gmail.com on Thu, 27 October 2016
6 587 Thu, 27 October 2016 11:51
By: Michel Cadot
  low value & high value
Oracle 11g
By: saipradyumn on Thu, 27 October 2016
2 591 Tue, 01 November 2016 06:58
By: saipradyumn
  Query Help
Oracle Database 11g 11.2.0.4.0
By: SADASIVAM on Thu, 27 October 2016
4 780 Wed, 02 November 2016 01:11
By: SADASIVAM
  Split Blog column to multiple columns within a row
By: alexust on Wed, 26 October 2016
4 531 Thu, 27 October 2016 15:01
By: Solomon Yakobson
  Materialized view creation with complex queries
11.2.0.4
By: grpatwari on Wed, 26 October 2016
12 954 Mon, 31 October 2016 04:18
By: grpatwari
  Query Help
Oracle Database 11g 11.2.0.4.0
By: SADASIVAM on Wed, 02 November 2016
0 878 Wed, 02 November 2016 01:08
By: SADASIVAM
  Table compression
Oracle 12c
By: srinivas.k2005 on Fri, 28 October 2016
15 821 Tue, 01 November 2016 15:28
By: John Watson
  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 958 Wed, 26 October 2016 10:14
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: Sat Oct 21 18:23:24 CDT 2017

Total time taken to generate the page: 0.24532 seconds