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
  Compare values based on range
By: rohit_shinez on Sat, 24 October 2015
27 821 Sun, 25 October 2015 13:28
By: Michel Cadot
  Is there a limitation of connect by for Partitioned tables
Oracle 11g
By: gentleman777us on Fri, 23 October 2015
1 341 Fri, 23 October 2015 12:15
By: Michel Cadot
  Need answer for below block
By: rajesh_oracle on Fri, 23 October 2015
1 416 Fri, 23 October 2015 02:13
By: Michel Cadot
  Unique hash based on user database objects.
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: tmcallister on Wed, 21 October 2015
7 697 Thu, 22 October 2015 19:23
By: BlackSwan
  get the remote DB instance name
Oracle 9i Release2 , HP UNIX
By: live4learn on Wed, 21 October 2015
5 2494 Wed, 21 October 2015 13:24
By: Solomon Yakobson
  interview question asked (merged 3)
By: purnima1 on Wed, 21 October 2015
3 519 Wed, 21 October 2015 10:47
By: Michel Cadot
  How to filter records from UNION ALL query
By: toitdoctor on Tue, 20 October 2015
4 2181 Wed, 21 October 2015 08:11
By: Michel Cadot
  Parallel Procedure Run
Oracle 11g, Windows 7
By: Vijay55 on Wed, 21 October 2015
2 1781 Wed, 21 October 2015 03:05
By: Michel Cadot
  Select with Time Range
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Mon, 19 October 2015
4 1985 Tue, 20 October 2015 09:42
By: Duane
  Insert into table from another table based on joining column
Oracle 10
By: pratik4891 on Tue, 20 October 2015
4 1874 Tue, 20 October 2015 07:49
By: Michel Cadot
  Filling values
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: manubatham20 on Mon, 19 October 2015
2 384 Mon, 19 October 2015 10:40
By: manubatham20
  user schema can't create or alter job (merged 3)
oracle 12GR2
By: agung_prw on Thu, 15 October 2015
20 4884 Mon, 19 October 2015 03:19
By: gazzag
  Need few clarification on Alter table.
Oracle 11G, WIN7
By: gopieee16 on Fri, 16 October 2015
6 534 Mon, 19 October 2015 02:16
By: gopieee16
  in, out parameters
By: wisdomofmetis on Sat, 17 October 2015
2 421 Sat, 17 October 2015 07:51
By: Solomon Yakobson
  Create table with two tablespaces
oracle 11g
By: raopatwariyahoocom on Fri, 16 October 2015
8 411 Fri, 16 October 2015 11:22
By: John Watson
  To replace value where the date falls
Oracle 11g
By: rohit_shinez on Fri, 16 October 2015
3 416 Fri, 16 October 2015 10:50
By: rohit_shinez
  binary to hexadecimal conversion
oracle 11gr2
By: guddu_12 on Fri, 16 October 2015
5 377 Fri, 16 October 2015 10:27
By: John Watson
  I need to process a string with arithmetic operators
By: spgun on Thu, 15 October 2015
3 423 Thu, 15 October 2015 11:44
By: Bill B
  split data with levels
11.2.0.3
By: amy.wilson on Fri, 09 October 2015
18 1709 Thu, 15 October 2015 02:18
By: flyboy
  fine tuning my sql query for a grouping report
oracle 10g, oracle forms and reports developer suite
By: lacchhii on Wed, 14 October 2015
1 385 Thu, 15 October 2015 01:25
By: Michel Cadot
  questions about creating function
By: wisdomofmetis on Tue, 13 October 2015
3 515 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 917 Tue, 13 October 2015 09:36
By: Bill B
  Regular Expression
Oracle 11.2.0.3
By: pointers on Thu, 08 October 2015
4 826 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 869 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 599 Tue, 13 October 2015 08:53
By: Bill B
  groups in regexp_instr
Oracle 10g
By: m.abdulhaq on Wed, 07 October 2015
6 722 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 835 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 527 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 488 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 529 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 588 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 852 Thu, 08 October 2015 08:02
By: Bill B
  query correction required
11g
By: amy.wilson on Wed, 07 October 2015
5 352 Wed, 07 October 2015 23:21
By: Michel Cadot
  CTE Queries
11g ( 1 2)
By: amy.wilson on Wed, 30 September 2015
43 1697 Wed, 07 October 2015 08:11
By: flyboy
  Checking the parameter inside Procedure (merged 2)
By: hypesslearner on Wed, 07 October 2015
3 302 Wed, 07 October 2015 06:25
By: Michel Cadot
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
62 1724 Tue, 06 October 2015 21:55
By: BlackSwan
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
2 464 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 967 Tue, 06 October 2015 01:08
By: Michel Cadot
  SQL with group by
Oracle SQL 11g
By: ramagirisrinivas on Fri, 02 October 2015
12 698 Mon, 05 October 2015 08:52
By: Michel Cadot
  Understand Difference between queries
By: purnima1 on Thu, 01 October 2015
5 477 Mon, 05 October 2015 04:29
By: purnima1
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: Tue May 31 20:47:09 CDT 2016

Total time taken to generate the page: 0.14842 seconds