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
icon11.gif HOW TO STORE ROWID DATA BY USING ROWID DATA TYPE?
oracle 11g
By: graphe on Tue, 13 October 2015
6 687 Tue, 13 October 2015 08:53
By: Bill B
  groups in regexp_instr
Oracle 10g
By: m.abdulhaq on Wed, 07 October 2015
6 850 Tue, 13 October 2015 04:12
By: m.abdulhaq
  How to get weeknum for the given date
By: blyzz on Fri, 09 October 2015
4 911 Mon, 12 October 2015 14:17
By: Michel Cadot
  single row subquery returns more than one row
11g R2
By: manoj12 on Mon, 12 October 2015
4 581 Mon, 12 October 2015 08:05
By: cookiemonster
  what is the main usage of execute immediate.
11g
By: sudheerips on Mon, 12 October 2015
3 566 Mon, 12 October 2015 05:08
By: _jum
  Rownum per day
Oracle DB 11.2.0.4
By: DirkHamburg on Fri, 09 October 2015
2 595 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 656 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 986 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 396 Wed, 07 October 2015 23:21
By: Michel Cadot
  CTE Queries
11g ( 1 2)
By: amy.wilson on Wed, 30 September 2015
43 1846 Wed, 07 October 2015 08:11
By: flyboy
  Checking the parameter inside Procedure (merged 2)
By: hypesslearner on Wed, 07 October 2015
3 379 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1884 Tue, 06 October 2015 21:55
By: BlackSwan
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
2 592 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 1099 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 821 Mon, 05 October 2015 08:52
By: Michel Cadot
  Understand Difference between queries
By: purnima1 on Thu, 01 October 2015
5 556 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 558 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 667 Thu, 01 October 2015 09:17
By: cookiemonster
  Check Constraints having alphanumeric
Oracle 10g
By: lokimisc on Wed, 30 September 2015
9 800 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 553 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 681 Thu, 01 October 2015 05:34
By: Michel Cadot
  Replace string based on condition
10g
By: m.abdulhaq on Thu, 01 October 2015
5 502 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 749 Thu, 01 October 2015 02:28
By: Michel Cadot
  Use of Force View
By: ashok_nr23 on Mon, 09 January 2006
5 7424 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 429 Wed, 30 September 2015 16:12
By: emyk
  MERGE and SEQUENCE
Oracle 11g
By: yepp on Tue, 29 September 2015
9 1033 Wed, 30 September 2015 08:10
By: Solomon Yakobson
  Recursive query
oracle11.2.0.3
By: vasudevaviswa on Wed, 30 September 2015
1 462 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 562 Mon, 28 September 2015 19:07
By: BlackSwan
  query rewrite
By: gidiyap on Sun, 27 September 2015
4 663 Mon, 28 September 2015 04:59
By: sandeep_orafaq
  NVL vs IS NULL
12c
By: deepakdot on Thu, 24 September 2015
12 1150 Fri, 25 September 2015 12:28
By: Michel Cadot
  Procedure call through java
By: rohit_shinez on Fri, 25 September 2015
3 482 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 649 Wed, 23 September 2015 22:44
By: Duane
  % with ROWNUM
SQL
By: battaarchana on Tue, 22 September 2015
11 752 Wed, 23 September 2015 07:39
By: Michel Cadot
  Calling Procedure
11g
By: P1Oracle on Thu, 17 September 2015
4 674 Wed, 23 September 2015 07:10
By: sandeep_orafaq
  Rownum
By: satheesh_ss on Wed, 18 July 2012
14 1340 Tue, 22 September 2015 09:01
By: Solomon Yakobson
  PLSQL_OPTIMIZE_LEVEL
12.x
By: John Watson on Tue, 22 September 2015
1 559 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 994 Tue, 22 September 2015 04:42
By: cookiemonster
  How to create named DEFAULT constraint
Oracle SQL
By: battaarchana on Tue, 15 September 2015
4 744 Tue, 22 September 2015 03:25
By: battaarchana
  Simple procedure
select into procedure
By: jclouser on Mon, 21 September 2015
5 540 Mon, 21 September 2015 15:02
By: Littlefoot
  How To Trunc Date In Oracle
By: swti6690 on Mon, 21 September 2015
6 647 Mon, 21 September 2015 07:16
By: cookiemonster
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: Wed Jan 18 16:49:45 CST 2017

Total time taken to generate the page: 0.10740 seconds