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
  questions about creating function
By: wisdomofmetis on Tue, 13 October 2015
3 586 Wed, 14 October 2015 09:48
By: CraigB
  Requirement to extract sql script output and attach the same in a email and send to multiple users
11g
By: avinashkk on Tue, 06 October 2015
9 983 Tue, 13 October 2015 09:36
By: Bill B
  Regular Expression
Oracle 11.2.0.3
By: pointers on Thu, 08 October 2015
4 874 Tue, 13 October 2015 09:27
By: Bill B
icon3.gif How To See Latest created Table Including Time in oracle. Is there any table for it?
Oarcle 11g
By: graphe on Thu, 08 October 2015
7 939 Tue, 13 October 2015 09:22
By: Bill B
icon11.gif HOW TO STORE ROWID DATA BY USING ROWID DATA TYPE?
oracle 11g
By: graphe on Tue, 13 October 2015
6 634 Tue, 13 October 2015 08:53
By: Bill B
  groups in regexp_instr
Oracle 10g
By: m.abdulhaq on Wed, 07 October 2015
6 805 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 877 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 554 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 526 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 564 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 615 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 911 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 378 Wed, 07 October 2015 23:21
By: Michel Cadot
  CTE Queries
11g ( 1 2)
By: amy.wilson on Wed, 30 September 2015
43 1763 Wed, 07 October 2015 08:11
By: flyboy
  Checking the parameter inside Procedure (merged 2)
By: hypesslearner on Wed, 07 October 2015
3 340 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1793 Tue, 06 October 2015 21:55
By: BlackSwan
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
2 527 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 1025 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 759 Mon, 05 October 2015 08:52
By: Michel Cadot
  Understand Difference between queries
By: purnima1 on Thu, 01 October 2015
5 514 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 494 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 582 Thu, 01 October 2015 09:17
By: cookiemonster
  Check Constraints having alphanumeric
Oracle 10g
By: lokimisc on Wed, 30 September 2015
9 697 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 461 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 616 Thu, 01 October 2015 05:34
By: Michel Cadot
  Replace string based on condition
10g
By: m.abdulhaq on Thu, 01 October 2015
5 469 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 728 Thu, 01 October 2015 02:28
By: Michel Cadot
  Use of Force View
By: ashok_nr23 on Mon, 09 January 2006
5 7286 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 393 Wed, 30 September 2015 16:12
By: emyk
  MERGE and SEQUENCE
Oracle 11g
By: yepp on Tue, 29 September 2015
9 890 Wed, 30 September 2015 08:10
By: Solomon Yakobson
  Recursive query
oracle11.2.0.3
By: vasudevaviswa on Wed, 30 September 2015
1 435 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 479 Mon, 28 September 2015 19:07
By: BlackSwan
  query rewrite
By: gidiyap on Sun, 27 September 2015
4 620 Mon, 28 September 2015 04:59
By: sandeep_orafaq
  NVL vs IS NULL
12c
By: deepakdot on Thu, 24 September 2015
12 1013 Fri, 25 September 2015 12:28
By: Michel Cadot
  Procedure call through java
By: rohit_shinez on Fri, 25 September 2015
3 449 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 576 Wed, 23 September 2015 22:44
By: Duane
  % with ROWNUM
SQL
By: battaarchana on Tue, 22 September 2015
11 690 Wed, 23 September 2015 07:39
By: Michel Cadot
  Calling Procedure
11g
By: thiruvari on Thu, 17 September 2015
4 635 Wed, 23 September 2015 07:10
By: sandeep_orafaq
  Rownum
By: satheesh_ss on Wed, 18 July 2012
14 1227 Tue, 22 September 2015 09:01
By: Solomon Yakobson
  PLSQL_OPTIMIZE_LEVEL
12.x
By: John Watson on Tue, 22 September 2015
1 498 Tue, 22 September 2015 04:46
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: Mon Aug 29 04:27:08 CDT 2016

Total time taken to generate the page: 0.16206 seconds