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
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 545 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 1370 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 384 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 388 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 368 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 323 Thu, 17 July 2014 21:33
By: Database admin
  archive & Purge of table
oracle 11g / Unix
By: balaji123 on Fri, 27 June 2014
7 600 Thu, 17 July 2014 12:34
By: Lalit Kumar B
  SQL ISSUE
oracle 11g / unix
By: balaji123 on Thu, 17 July 2014
3 265 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 542 Thu, 17 July 2014 11:22
By: Littlefoot
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1333 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 537 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 490 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 361 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 665 Wed, 16 July 2014 01:22
By: afzaa2yahoocom
  Prior Week Saturday Date
Oracle 10g
By: gauravgautam135 on Tue, 15 July 2014
12 736 Wed, 16 July 2014 00:48
By: gauravgautam135
  Query
By: simiha on Tue, 15 July 2014
2 288 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 273 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 507 Tue, 15 July 2014 11:36
By: itmasterw
  oracle 11g along with XML
Oracle 11g
By: ashish_sun123 on Mon, 14 July 2014
7 558 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 397 Tue, 15 July 2014 08:59
By: Solomon Yakobson
  Execute immediate ( 1 2)
By: purnima1 on Wed, 09 July 2014
42 1423 Tue, 15 July 2014 05:02
By: purnima1
  Does not exist
oracle 10g
By: thelearner on Mon, 14 July 2014
2 299 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 761 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 352 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 279 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 259 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 1051 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 716 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 701 Sun, 13 July 2014 12:53
By: Kevin Meade
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 4036 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 485 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 448 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 399 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 923 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 355 Fri, 11 July 2014 02:28
By: Lalit Kumar B
  SQL
By: newastrum on Thu, 10 July 2014
3 390 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 508 Thu, 10 July 2014 08:04
By: Michel Cadot
  pls help in query
pl sql
By: simplesanju on Wed, 19 February 2014
8 756 Thu, 10 July 2014 07:33
By: Roachcoach
  Refcursor with returning resultset
Oracle 10g
By: sss111ind on Tue, 08 July 2014
15 681 Thu, 10 July 2014 06:04
By: Lalit Kumar B
  query to find reserved words
10.2.0.4.0
By: grpatwari on Thu, 10 July 2014
3 532 Thu, 10 July 2014 05:15
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: Sun Feb 01 09:04:04 CST 2015

Total time taken to generate the page: 0.11588 seconds