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
  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 982 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 938 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 633 Tue, 13 October 2015 08:53
By: Bill B
  groups in regexp_instr
Oracle 10g
By: m.abdulhaq on Wed, 07 October 2015
6 804 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 614 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 910 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 377 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 339 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1788 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 1022 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 758 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 493 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 581 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 458 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 468 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 727 Thu, 01 October 2015 02:28
By: Michel Cadot
  Use of Force View
By: ashok_nr23 on Mon, 09 January 2006
5 7282 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 391 Wed, 30 September 2015 16:12
By: emyk
  MERGE and SEQUENCE
Oracle 11g
By: yepp on Tue, 29 September 2015
9 888 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 618 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 448 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 574 Wed, 23 September 2015 22:44
By: Duane
  % with ROWNUM
SQL
By: battaarchana on Tue, 22 September 2015
11 689 Wed, 23 September 2015 07:39
By: Michel Cadot
  Calling Procedure
11g
By: thiruvari on Thu, 17 September 2015
4 634 Wed, 23 September 2015 07:10
By: sandeep_orafaq
  Rownum
By: satheesh_ss on Wed, 18 July 2012
14 1226 Tue, 22 September 2015 09:01
By: Solomon Yakobson
  PLSQL_OPTIMIZE_LEVEL
12.x
By: John Watson on Tue, 22 September 2015
1 496 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 938 Tue, 22 September 2015 04:42
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: Sat Aug 27 10:34:08 CDT 2016

Total time taken to generate the page: 0.17086 seconds