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 For N number to top Sales in Region
oracle 10 g
By: annu-agi on Sun, 04 December 2016
6 1010 Mon, 05 December 2016 01:18
By: Michel Cadot
  Element exists in a collection
Oracle 11.2.0.3
By: pointers on Fri, 02 December 2016
3 1177 Fri, 02 December 2016 06:43
By: Solomon Yakobson
  How to check if time is attached with date?
10.2.0
By: bluetooth420 on Wed, 30 November 2016
11 2151 Fri, 02 December 2016 03:14
By: cookiemonster
  ora-06504 PL/SQL: Return types of Result Set variables or query do not match
By: v4goel on Thu, 25 October 2007
11 13056 Thu, 01 December 2016 12:39
By: Michel Cadot
  Function MAX
Oracle 11g
By: tomekw on Thu, 01 December 2016
3 928 Thu, 01 December 2016 10:08
By: Michel Cadot
  how to search for two characters in any sequence, with or without alphanumeric characters in between
Oracle 11g, 12c
By: namitanamburi on Tue, 29 November 2016
13 1380 Tue, 29 November 2016 15:36
By: Bill B
  Star printing in PL/SQL Program Problem
11g
By: ashishpatel1992 on Sat, 16 March 2013
13 10037 Tue, 29 November 2016 14:06
By: Michel Cadot
  How to pass date parameters in dynamic sql?
PL sql
By: nukala on Mon, 28 November 2016
8 1545 Tue, 29 November 2016 07:38
By: EdStevens
  Function returns Record - How to select
By: vactirio on Fri, 25 November 2016
8 1382 Sat, 26 November 2016 06:44
By: vactirio
  How to generate a insert script as it is what ever we running the insert script?
insert into dept(deptno,dname,loc) values (70,'PERSONNEL','DALLAS')
By: narendraenamala on Thu, 24 November 2016
9 1872 Sat, 26 November 2016 04:40
By: Michel Cadot
  using rownum
oracle 10 g
By: akash123 on Fri, 25 November 2016
14 2138 Fri, 25 November 2016 07:06
By: Bill B
  Trigger to prevent update/delete/insert operation
By: ram_new_to_oracle on Thu, 24 November 2016
4 1268 Fri, 25 November 2016 03:18
By: cookiemonster
  Trigger to prevent delete according to select
11.0.2.10
By: OraFerro on Tue, 22 November 2016
9 1656 Thu, 24 November 2016 08:16
By: ALEXWE
  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 775 Thu, 24 November 2016 07:20
By: John Watson
  SQL Query Update
11g
By: glmjoy on Thu, 24 November 2016
4 834 Thu, 24 November 2016 06:11
By: msol25
  complex query
oracle
By: bikashp on Wed, 23 November 2016
1 748 Wed, 23 November 2016 06:35
By: Michel Cadot
  electronic data sharding
By: sudeepto chattaraj on Fri, 18 November 2016
14 2215 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 7269 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 1057 Mon, 21 November 2016 03:09
By: Michel Cadot
  Rows not populating
Oracle DB 12c
By: krishna.orcl97 on Fri, 18 November 2016
9 1172 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 733 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 2165 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 858 Wed, 16 November 2016 10:32
By: Michel Cadot
  merge statement problem
10g
By: emadnabil on Sun, 13 November 2016
15 2320 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 1563 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 11083 Mon, 14 November 2016 00:21
By: Shan.kumar
icon9.gif PL/SQL Email
Oracle 11gr2
By: VariableReset on Sat, 12 November 2016
3 1148 Sat, 12 November 2016 06:48
By: VariableReset
  SQL Query Request
oracle 11g
By: raj85844 on Wed, 09 November 2016
14 2298 Fri, 11 November 2016 10:19
By: Michel Cadot
  spool sql data in excel multi sheets
By: Preeti123456 on Thu, 10 November 2016
3 1052 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 614 Wed, 09 November 2016 12:22
By: BlackSwan
  Search data between months
Oracle 11g
By: Xandot on Wed, 09 November 2016
2 683 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 1043 Wed, 09 November 2016 03:01
By: Flyby
  Query help
Oracle
By: julien1630 on Tue, 08 November 2016
14 10386 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 2784 Tue, 08 November 2016 07:06
By: EdStevens
  Procedure execution issue and trace
11g r2, linux
By: qazims92 on Mon, 07 November 2016
7 1012 Tue, 08 November 2016 03:56
By: cookiemonster
  conversion to 16bit decimal
oracle 11gr2
By: guddu_12 on Fri, 28 October 2016
16 2325 Mon, 07 November 2016 10:09
By: guddu_12
  Conditional based default value
Oracle 11
By: saipradyumn on Mon, 07 November 2016
5 785 Mon, 07 November 2016 08:05
By: saipradyumn
  package modified details
oracle 12c, unix
By: pstanand on Sun, 06 November 2016
6 761 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 650 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 3916 Fri, 04 November 2016 11:24
By: Solomon Yakobson
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 Nov 18 03:57:43 CST 2018