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
  Binary tree in Pl/sql
By: suni786 on Mon, 14 January 2013
6 1238 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 472 Thu, 17 July 2014 06:07
By: Thilinaa
  Materialized view
11g
By: mvrkr44 on Wed, 16 July 2014
9 444 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 321 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 581 Wed, 16 July 2014 01:22
By: afzaa2yahoocom
  Prior Week Saturday Date
Oracle 10g
By: gauravgautam135 on Tue, 15 July 2014
12 679 Wed, 16 July 2014 00:48
By: gauravgautam135
  Query
By: simiha on Tue, 15 July 2014
2 258 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 249 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 457 Tue, 15 July 2014 11:36
By: itmasterw
  oracle 11g along with XML
Oracle 11g
By: ashish_sun123 on Mon, 14 July 2014
7 503 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 346 Tue, 15 July 2014 08:59
By: Solomon Yakobson
  Execute immediate ( 1 2)
By: purnima1 on Wed, 09 July 2014
42 1332 Tue, 15 July 2014 05:02
By: purnima1
  Does not exist
oracle 10g
By: thelearner on Mon, 14 July 2014
2 280 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 721 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 318 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 238 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 220 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 949 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 659 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 606 Sun, 13 July 2014 12:53
By: Kevin Meade
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 3876 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 463 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 339 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 351 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 852 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 296 Fri, 11 July 2014 02:28
By: Lalit Kumar B
  SQL
By: newastrum on Thu, 10 July 2014
3 345 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 445 Thu, 10 July 2014 08:04
By: Michel Cadot
  pls help in query
pl sql
By: simplesanju on Wed, 19 February 2014
8 682 Thu, 10 July 2014 07:33
By: Roachcoach
  Refcursor with returning resultset
Oracle 10g
By: sss111ind on Tue, 08 July 2014
15 618 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 378 Thu, 10 July 2014 05:15
By: Michel Cadot
  help in sql query
sql
By: simplesanju on Fri, 03 January 2014
5 632 Thu, 10 July 2014 02:33
By: simplesanju
  IN CLAUSE OUTPUT
By: anniepeteroracle on Wed, 09 July 2014
6 493 Thu, 10 July 2014 01:07
By: Michel Cadot
  SQL Group Query
11g
By: tabj on Wed, 09 July 2014
5 464 Wed, 09 July 2014 23:24
By: tabj
  Subquery vs. Join performance (optimizer)
Oracle 11g
By: rc3d on Tue, 08 July 2014
6 428 Wed, 09 July 2014 04:14
By: rc3d
  Packages
10g database, oracle 9i
By: vippysharma on Wed, 09 July 2014
2 316 Wed, 09 July 2014 02:20
By: Michel Cadot
  comparing collections
By: purnima1 on Fri, 04 July 2014
9 613 Wed, 09 July 2014 01:28
By: purnima1
  What is Analytical function?
11g
By: sachinpawar80 on Mon, 07 July 2014
4 513 Wed, 09 July 2014 00:02
By: sachinpawar80
  column name and procedure parameter are same in oracle
Oracle 10g
By: sss111ind on Tue, 08 July 2014
6 332 Tue, 08 July 2014 06:40
By: EdStevens
  regarding sql query
By: IRFANMBAIG on Tue, 08 July 2014
5 308 Tue, 08 July 2014 05:59
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: Fri Nov 28 02:35:13 CST 2014

Total time taken to generate the page: 0.11812 seconds