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
  Reverse Engineer any Object
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Sun, 20 July 2014
4 258 Sun, 20 July 2014 22:53
By: Lalit Kumar B
  why use BETWEEN? BETWEEN vs. <= and >=
Oracle 11g
By: rc3d on Sun, 20 July 2014
6 279 Sun, 20 July 2014 13:54
By: rc3d
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 400 Fri, 18 July 2014 14:15
By: Bill B
  Searching a string and replacing with value
Oracle 10g
By: sss111ind on Fri, 11 April 2014
15 1170 Fri, 18 July 2014 10:42
By: Lalit Kumar B
  Reading the xml value
Oralce 10g
By: sss111ind on Thu, 17 July 2014
20 536 Fri, 18 July 2014 09:42
By: Lalit Kumar B
  Single select query or multiple cursor output as collection
By: ORAGENASHOK on Thu, 17 July 2014
4 231 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 263 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 249 Fri, 18 July 2014 03:25
By: ric90
  View is invalid
Oracle 11g,Linux 2.6
By: Database admin on Thu, 17 July 2014
5 202 Thu, 17 July 2014 21:33
By: Database admin
  archive & Purge of table
oracle 11g / Unix
By: balaji123 on Fri, 27 June 2014
7 355 Thu, 17 July 2014 12:34
By: Lalit Kumar B
  SQL ISSUE
oracle 11g / unix
By: balaji123 on Thu, 17 July 2014
3 164 Thu, 17 July 2014 12:33
By: balaji123
  get every result of a query to use after other query
By: mmm286 on Thu, 17 July 2014
17 406 Thu, 17 July 2014 11:22
By: Littlefoot
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1069 Thu, 17 July 2014 06:54
By: Littlefoot
  Dbms_Parallel_Execute.Run_Task gets stuck
Oracle Database 11g Release 11.2.0.4.0
By: Thilinaa on Thu, 17 July 2014
0 366 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 325 Wed, 16 July 2014 10:26
By: Michel Cadot
  Diffrent Number and type of parameter passing
11g
By: dara.naveen on Mon, 14 July 2014
3 258 Wed, 16 July 2014 02:32
By: Michel Cadot
  Query to get payroll values between dates
EBS R12.1.3, Oracle 11g
By: afzaa2yahoocom on Tue, 15 July 2014
4 242 Wed, 16 July 2014 01:22
By: afzaa2yahoocom
  Prior Week Saturday Date
Oracle 10g
By: gauravgautam135 on Tue, 15 July 2014
12 573 Wed, 16 July 2014 00:48
By: gauravgautam135
  Query
By: simiha on Tue, 15 July 2014
2 180 Tue, 15 July 2014 15:07
By: Michel Cadot
  How to check words from two columns in a table and give count
By: sasank54 on Tue, 15 July 2014
1 149 Tue, 15 July 2014 14:14
By: Solomon Yakobson
icon5.gif Declare and assign a value ot a variable
Oracle 11, SQL developer
By: itmasterw on Mon, 14 July 2014
11 357 Tue, 15 July 2014 11:36
By: itmasterw
  oracle 11g along with XML
Oracle 11g
By: ashish_sun123 on Mon, 14 July 2014
7 401 Tue, 15 July 2014 10:32
By: Lalit Kumar B
  Format a String to 2 decimal place
By: jimjohn on Tue, 15 July 2014
11 259 Tue, 15 July 2014 08:59
By: Solomon Yakobson
  Execute immediate ( 1 2)
By: purnima1 on Wed, 09 July 2014
42 1131 Tue, 15 July 2014 05:02
By: purnima1
  Does not exist
oracle 10g
By: thelearner on Mon, 14 July 2014
2 222 Tue, 15 July 2014 00:26
By: Michel Cadot
  Sql Query to see the sales between dates
Oracle 11g, Windows 7
By: afzaa2yahoocom on Fri, 11 July 2014
12 583 Mon, 14 July 2014 14:02
By: Lalit Kumar B
  Method to take table backup
Oracle 11g, Linux
By: Database admin on Mon, 14 July 2014
5 239 Mon, 14 July 2014 07:57
By: Database admin
  what does table.column = table.column(+) refer to
By: stahorse on Mon, 14 July 2014
2 154 Mon, 14 July 2014 03:51
By: cookiemonster
  Result as per Double Outer Join ?
10.2.0
By: bluetooth420 on Mon, 14 July 2014
3 152 Mon, 14 July 2014 03:01
By: bluetooth420
  how to get script of table in sql plus
oracle 8i
By: jgjeetu on Tue, 01 July 2014
27 795 Sun, 13 July 2014 14:08
By: Lalit Kumar B
  how to display any particular column first using select * query.
oracle 10g sql plus
By: jgjeetu on Fri, 11 July 2014
16 539 Sun, 13 July 2014 13:52
By: Lalit Kumar B
  Order of WHERE columns doesn't matter? The optimizer will handle that?
Oracle 11g
By: rc3d on Sun, 06 July 2014
9 475 Sun, 13 July 2014 12:53
By: Kevin Meade
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 3618 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 371 Sat, 12 July 2014 04:04
By: Lalit Kumar B
  Parse XML to Oracle Database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0, Windows 7 64 Bit
By: jtnganga@gmail.com on Fri, 11 July 2014
1 193 Sat, 12 July 2014 01:25
By: Michel Cadot
icon5.gif Like function with Parameters
Oracle 11, toad, and SQL developer
By: itmasterw on Fri, 11 July 2014
8 247 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 709 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 185 Fri, 11 July 2014 02:28
By: Lalit Kumar B
  SQL
By: newastrum on Thu, 10 July 2014
3 256 Thu, 10 July 2014 08:34
By: pablolee
  pass parameter into the Procedure , which are passing into the Cursor for loop in the Another Proced
By: mist598 on Thu, 10 July 2014
13 338 Thu, 10 July 2014 08:04
By: Michel Cadot
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: Thu Jul 31 03:56:24 CDT 2014

Total time taken to generate the page: 0.07459 seconds