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
  SQL
9i, 10g
By: glmjoy on Tue, 22 July 2014
2 178 Tue, 22 July 2014 03:54
By: Lalit Kumar B
  SubQuery Problem
Oracle SQL Developer 3.1.07
By: HeyMoe on Wed, 16 July 2014
13 683 Tue, 22 July 2014 02:17
By: flyboy
  use between in case on one fild
By: hahaie on Mon, 21 July 2014
8 296 Tue, 22 July 2014 01:20
By: Michel Cadot
icon14.gif date function
By: hahaie on Sun, 20 July 2014
6 379 Tue, 22 July 2014 00:11
By: Lalit Kumar B
  Oracle RDBMS equivalent for CONCAT_WS() - create CSV output
Oracle 11g
By: rc3d on Mon, 21 July 2014
9 295 Mon, 21 July 2014 14:04
By: Lalit Kumar B
  how can i used connect by prior function.
oracle10g
By: ajamitjain129@gmail.com on Fri, 18 July 2014
24 888 Mon, 21 July 2014 08:24
By: Michel Cadot
  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 263 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 293 Sun, 20 July 2014 13:54
By: rc3d
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 415 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 1194 Fri, 18 July 2014 10:42
By: Lalit Kumar B
  Single select query or multiple cursor output as collection
By: ORAGENASHOK on Thu, 17 July 2014
4 246 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 268 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 251 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 208 Thu, 17 July 2014 21:33
By: Database admin
  archive & Purge of table
oracle 11g / Unix
By: balaji123 on Fri, 27 June 2014
7 374 Thu, 17 July 2014 12:34
By: Lalit Kumar B
  SQL ISSUE
oracle 11g / unix
By: balaji123 on Thu, 17 July 2014
3 170 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 416 Thu, 17 July 2014 11:22
By: Littlefoot
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1097 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 389 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 344 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 266 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 256 Wed, 16 July 2014 01:22
By: afzaa2yahoocom
  Prior Week Saturday Date
Oracle 10g
By: gauravgautam135 on Tue, 15 July 2014
12 588 Wed, 16 July 2014 00:48
By: gauravgautam135
  Query
By: simiha on Tue, 15 July 2014
2 185 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 161 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 377 Tue, 15 July 2014 11:36
By: itmasterw
  oracle 11g along with XML
Oracle 11g
By: ashish_sun123 on Mon, 14 July 2014
7 411 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 268 Tue, 15 July 2014 08:59
By: Solomon Yakobson
  Execute immediate ( 1 2)
By: purnima1 on Wed, 09 July 2014
42 1165 Tue, 15 July 2014 05:02
By: purnima1
  Does not exist
oracle 10g
By: thelearner on Mon, 14 July 2014
2 224 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 607 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 249 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 158 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 158 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 818 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 560 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 501 Sun, 13 July 2014 12:53
By: Kevin Meade
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 3662 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 390 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 219 Sat, 12 July 2014 01:25
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 Aug 21 10:03:39 CDT 2014

Total time taken to generate the page: 0.13242 seconds