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
  Rownum per day
Oracle DB 11.2.0.4
By: DirkHamburg on Fri, 09 October 2015
2 568 Fri, 09 October 2015 07:13
By: DirkHamburg
  set target table flag as D if rows deleted at source
oracle 11.2
By: deb171100 on Thu, 08 October 2015
2 619 Fri, 09 October 2015 02:28
By: sandeep_orafaq
  required date month year query
oracle 10g express edition
By: sudheerips on Fri, 02 October 2015
10 920 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 383 Wed, 07 October 2015 23:21
By: Michel Cadot
  CTE Queries
11g ( 1 2)
By: amy.wilson on Wed, 30 September 2015
43 1780 Wed, 07 October 2015 08:11
By: flyboy
  Checking the parameter inside Procedure (merged 2)
By: hypesslearner on Wed, 07 October 2015
3 349 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1809 Tue, 06 October 2015 21:55
By: BlackSwan
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
2 543 Tue, 06 October 2015 05:38
By: Amine
icon5.gif What is the Difference b/w Up datable Views and Non-Up datable Views their uses
Oracle 11g
By: graphe on Thu, 01 October 2015
13 1036 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 774 Mon, 05 October 2015 08:52
By: Michel Cadot
  Understand Difference between queries
By: purnima1 on Thu, 01 October 2015
5 520 Mon, 05 October 2015 04:29
By: purnima1
  insert data into column same table
oracle,11.2.0.3,win 07
By: ORA456 on Sat, 03 October 2015
2 504 Sat, 03 October 2015 09:22
By: Michel Cadot
  HOW TO UPDATE ONE FIELD IN A TABLE BASED ON OTHER ?
ORACLE 11G
By: ibnelyas on Thu, 01 October 2015
9 597 Thu, 01 October 2015 09:17
By: cookiemonster
  Check Constraints having alphanumeric
Oracle 10g
By: lokimisc on Wed, 30 September 2015
9 721 Thu, 01 October 2015 09:13
By: lokimisc
  DBMS_AQ
10.1.0.5.0 - 64bit, Windows 7
By: suyogsheth on Thu, 01 October 2015
4 488 Thu, 01 October 2015 06:38
By: Michel Cadot
  SQL*Net message from dblink
Oracle 11g
By: mad_man12 on Thu, 01 October 2015
7 628 Thu, 01 October 2015 05:34
By: Michel Cadot
  Replace string based on condition
10g
By: m.abdulhaq on Thu, 01 October 2015
5 471 Thu, 01 October 2015 04:20
By: m.abdulhaq
  Oracle Defined Function (DECODE)
oracle all versions
By: adi_gang on Thu, 01 October 2015
1 737 Thu, 01 October 2015 02:28
By: Michel Cadot
  Use of Force View
By: ashok_nr23 on Mon, 09 January 2006
5 7319 Thu, 01 October 2015 01:03
By: graphe
  Unable to pass date variables into a stored procedure
Oracle SQL
By: emyk on Wed, 30 September 2015
2 404 Wed, 30 September 2015 16:12
By: emyk
  MERGE and SEQUENCE
Oracle 11g
By: yepp on Tue, 29 September 2015
9 920 Wed, 30 September 2015 08:10
By: Solomon Yakobson
  Recursive query
oracle11.2.0.3
By: vasudevaviswa on Wed, 30 September 2015
1 446 Wed, 30 September 2015 04:29
By: Lalit Kumar B
  No numbers on Imbalance and Variance...
11.2.0.3.x and Solaris 10
By: James Bennett on Mon, 28 September 2015
5 497 Mon, 28 September 2015 19:07
By: BlackSwan
  query rewrite
By: gidiyap on Sun, 27 September 2015
4 628 Mon, 28 September 2015 04:59
By: sandeep_orafaq
  NVL vs IS NULL
12c
By: deepakdot on Thu, 24 September 2015
12 1036 Fri, 25 September 2015 12:28
By: Michel Cadot
  Procedure call through java
By: rohit_shinez on Fri, 25 September 2015
3 460 Fri, 25 September 2015 11:25
By: Michel Cadot
  Using Procedure/Function in a Select Statement
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Wed, 23 September 2015
8 591 Wed, 23 September 2015 22:44
By: Duane
  % with ROWNUM
SQL
By: battaarchana on Tue, 22 September 2015
11 699 Wed, 23 September 2015 07:39
By: Michel Cadot
  Calling Procedure
11g
By: thiruvari on Thu, 17 September 2015
4 639 Wed, 23 September 2015 07:10
By: sandeep_orafaq
  Rownum
By: satheesh_ss on Wed, 18 July 2012
14 1239 Tue, 22 September 2015 09:01
By: Solomon Yakobson
  PLSQL_OPTIMIZE_LEVEL
12.x
By: John Watson on Tue, 22 September 2015
1 518 Tue, 22 September 2015 04:46
By: cookiemonster
  Get Max Value of Date Column With Condition
11g
By: elmousa68 on Tue, 22 September 2015
13 956 Tue, 22 September 2015 04:42
By: cookiemonster
  How to create named DEFAULT constraint
Oracle SQL
By: battaarchana on Tue, 15 September 2015
4 662 Tue, 22 September 2015 03:25
By: battaarchana
  Simple procedure
select into procedure
By: jclouser on Mon, 21 September 2015
5 499 Mon, 21 September 2015 15:02
By: Littlefoot
  How To Trunc Date In Oracle
By: swti6690 on Mon, 21 September 2015
6 589 Mon, 21 September 2015 07:16
By: cookiemonster
  How to select last rate of Product
10g
By: manisngpl on Sat, 19 September 2015
4 665 Mon, 21 September 2015 04:47
By: dude4084
  merge statement (merged :)
By: sa_dwhite on Sat, 19 September 2015
15 932 Mon, 21 September 2015 02:58
By: flyboy
  how to loop within sql statement without using PL/SQL Block
By: ramya29p on Thu, 17 September 2015
6 669 Mon, 21 September 2015 01:21
By: Michel Cadot
  query same table multiple times
Oracle DB 11gR2
By: hungman on Sun, 20 September 2015
0 640 Sun, 20 September 2015 20:49
By: hungman
  pl/sql
By: ORA456 on Sun, 20 September 2015
4 498 Sun, 20 September 2015 11:43
By: ORA456
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 Sep 25 11:06:40 CDT 2016

Total time taken to generate the page: 0.20138 seconds