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
icon14.gif date function
By: hahaie on Sun, 20 July 2014
6 596 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 881 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 1183 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 460 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 486 Sun, 20 July 2014 13:54
By: rc3d
  Table statistics
11g
By: andrewscharles89 on Mon, 14 July 2014
4 592 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 1492 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 437 Fri, 18 July 2014 07:40
By: ORAGENASHOK
  Using Case statement after "AND"
Oracle SQL Developer
By: rksample on Fri, 18 July 2014
5 437 Fri, 18 July 2014 06:57
By: Littlefoot
  Rebuild tree with fullpath - connect by (?)
11gR2
By: ric90 on Thu, 17 July 2014
7 420 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 352 Thu, 17 July 2014 21:33
By: Database admin
  archive & Purge of table
oracle 11g / Unix
By: balaji123 on Fri, 27 June 2014
7 731 Thu, 17 July 2014 12:34
By: Lalit Kumar B
  SQL ISSUE
oracle 11g / unix
By: balaji123 on Thu, 17 July 2014
3 284 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 592 Thu, 17 July 2014 11:22
By: Littlefoot
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1445 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 579 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 533 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 383 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 807 Wed, 16 July 2014 01:22
By: afzaa2yahoocom
  Prior Week Saturday Date
Oracle 10g
By: gauravgautam135 on Tue, 15 July 2014
12 790 Wed, 16 July 2014 00:48
By: gauravgautam135
  Query
By: simiha on Tue, 15 July 2014
2 319 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 293 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 554 Tue, 15 July 2014 11:36
By: itmasterw
  oracle 11g along with XML
Oracle 11g
By: ashish_sun123 on Mon, 14 July 2014
7 626 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 456 Tue, 15 July 2014 08:59
By: Solomon Yakobson
  Execute immediate ( 1 2)
By: purnima1 on Wed, 09 July 2014
42 1572 Tue, 15 July 2014 05:02
By: purnima1
  Does not exist
oracle 10g
By: thelearner on Mon, 14 July 2014
2 326 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 816 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 395 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 346 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 342 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 1135 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 765 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 763 Sun, 13 July 2014 12:53
By: Kevin Meade
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 4216 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 520 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 524 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 432 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 982 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 385 Fri, 11 July 2014 02:28
By: Lalit Kumar B
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: Fri May 29 22:22:10 CDT 2015

Total time taken to generate the page: 0.36343 seconds