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 616 Tue, 13 October 2015 08:53
By: Bill B
  groups in regexp_instr
Oracle 10g
By: m.abdulhaq on Wed, 07 October 2015
6 756 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 848 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 539 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 497 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 543 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 596 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 875 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 362 Wed, 07 October 2015 23:21
By: Michel Cadot
  CTE Queries
11g ( 1 2)
By: amy.wilson on Wed, 30 September 2015
43 1727 Wed, 07 October 2015 08:11
By: flyboy
  Checking the parameter inside Procedure (merged 2)
By: hypesslearner on Wed, 07 October 2015
3 320 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1743 Tue, 06 October 2015 21:55
By: BlackSwan
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
2 492 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 989 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 719 Mon, 05 October 2015 08:52
By: Michel Cadot
  Understand Difference between queries
By: purnima1 on Thu, 01 October 2015
5 491 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 461 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 533 Thu, 01 October 2015 09:17
By: cookiemonster
  Check Constraints having alphanumeric
Oracle 10g
By: lokimisc on Wed, 30 September 2015
9 642 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 408 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 585 Thu, 01 October 2015 05:34
By: Michel Cadot
  Replace string based on condition
10g
By: m.abdulhaq on Thu, 01 October 2015
5 459 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 710 Thu, 01 October 2015 02:28
By: Michel Cadot
  Use of Force View
By: ashok_nr23 on Mon, 09 January 2006
5 7200 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 376 Wed, 30 September 2015 16:12
By: emyk
  MERGE and SEQUENCE
Oracle 11g
By: yepp on Tue, 29 September 2015
9 834 Wed, 30 September 2015 08:10
By: Solomon Yakobson
  Recursive query
oracle11.2.0.3
By: vasudevaviswa on Wed, 30 September 2015
1 417 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 429 Mon, 28 September 2015 19:07
By: BlackSwan
  query rewrite
By: gidiyap on Sun, 27 September 2015
4 594 Mon, 28 September 2015 04:59
By: sandeep_orafaq
  NVL vs IS NULL
12c
By: deepakdot on Thu, 24 September 2015
12 929 Fri, 25 September 2015 12:28
By: Michel Cadot
  Procedure call through java
By: rohit_shinez on Fri, 25 September 2015
3 419 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 537 Wed, 23 September 2015 22:44
By: Duane
  % with ROWNUM
SQL
By: battaarchana on Tue, 22 September 2015
11 668 Wed, 23 September 2015 07:39
By: Michel Cadot
  Calling Procedure
11g
By: thiruvari on Thu, 17 September 2015
4 617 Wed, 23 September 2015 07:10
By: sandeep_orafaq
  Rownum
By: satheesh_ss on Wed, 18 July 2012
14 1185 Tue, 22 September 2015 09:01
By: Solomon Yakobson
  PLSQL_OPTIMIZE_LEVEL
12.x
By: John Watson on Tue, 22 September 2015
1 453 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 914 Tue, 22 September 2015 04:42
By: cookiemonster
  How to create named DEFAULT constraint
Oracle SQL
By: battaarchana on Tue, 15 September 2015
4 614 Tue, 22 September 2015 03:25
By: battaarchana
  Simple procedure
select into procedure
By: jclouser on Mon, 21 September 2015
5 460 Mon, 21 September 2015 15:02
By: Littlefoot
  How To Trunc Date In Oracle
By: swti6690 on Mon, 21 September 2015
6 535 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 Jun 29 19:00:31 CDT 2016

Total time taken to generate the page: 0.14479 seconds