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
  SYS_CONNECT_BY_PATH
oracle 10g
By: Mahesh P on Tue, 23 June 2009
8 3942 Sat, 12 July 2014 08:03
By: Solomon Yakobson
  CBO
oracle 11g / unix
By: balaji123 on Thu, 03 July 2014
6 467 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 411 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 363 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 875 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 309 Fri, 11 July 2014 02:28
By: Lalit Kumar B
  SQL
By: newastrum on Thu, 10 July 2014
3 350 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 465 Thu, 10 July 2014 08:04
By: Michel Cadot
  pls help in query
pl sql
By: simplesanju on Wed, 19 February 2014
8 705 Thu, 10 July 2014 07:33
By: Roachcoach
  Refcursor with returning resultset
Oracle 10g
By: sss111ind on Tue, 08 July 2014
15 638 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 399 Thu, 10 July 2014 05:15
By: Michel Cadot
  help in sql query
sql
By: simplesanju on Fri, 03 January 2014
5 654 Thu, 10 July 2014 02:33
By: simplesanju
  IN CLAUSE OUTPUT
By: anniepeteroracle on Wed, 09 July 2014
6 513 Thu, 10 July 2014 01:07
By: Michel Cadot
  SQL Group Query
11g
By: tabj on Wed, 09 July 2014
5 480 Wed, 09 July 2014 23:24
By: tabj
  Subquery vs. Join performance (optimizer)
Oracle 11g
By: rc3d on Tue, 08 July 2014
6 447 Wed, 09 July 2014 04:14
By: rc3d
  Packages
10g database, oracle 9i
By: vippysharma on Wed, 09 July 2014
2 323 Wed, 09 July 2014 02:20
By: Michel Cadot
  comparing collections
By: purnima1 on Fri, 04 July 2014
9 637 Wed, 09 July 2014 01:28
By: purnima1
  What is Analytical function?
11g
By: sachinpawar80 on Mon, 07 July 2014
4 531 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 347 Tue, 08 July 2014 06:40
By: EdStevens
  regarding sql query
By: IRFANMBAIG on Tue, 08 July 2014
5 327 Tue, 08 July 2014 05:59
By: Michel Cadot
  how to recover data from clob
Oracle 11g
By: zhaoquer on Wed, 02 July 2014
14 477 Tue, 08 July 2014 04:37
By: zhaoquer
  ORA-29285: file write error
By: Srini1234 on Tue, 24 May 2005
3 36642 Tue, 08 July 2014 01:56
By: Dina.1423
  Add records in collection
Pl/sql/11.2.0.2.0., Win7
By: shumail on Sun, 06 July 2014
10 504 Mon, 07 July 2014 12:25
By: shumail
  Autocomplete
11g Release 2 Windows
By: Duane on Mon, 07 July 2014
2 264 Mon, 07 July 2014 10:26
By: Duane
  Oracle SQL - break up sequential records with the same value
11GR2
By: dgloeppky on Thu, 03 July 2014
4 384 Mon, 07 July 2014 08:49
By: Michel Cadot
  Order of item list in declaration part of PL/SQL anonymous block
By: Lalit Kumar B on Sat, 05 July 2014
8 571 Mon, 07 July 2014 07:19
By: Lalit Kumar B
  what plsqls of this output?
By: hahaie on Sun, 06 July 2014
3 305 Mon, 07 July 2014 06:23
By: Lalit Kumar B
  query to find tablename, bindvariable column names
10.2.0.4
By: grpatwari on Mon, 07 July 2014
3 324 Mon, 07 July 2014 02:40
By: Michel Cadot
  First Character Encountered Capitalised and rest in lower
Oracle 10G
By: gauravgautam135 on Fri, 04 July 2014
10 538 Mon, 07 July 2014 01:32
By: gauravgautam135
  BULK COLLECT -not getting expected result
oracle 10g,windows 7
By: harishankar_kar on Sun, 06 July 2014
10 438 Mon, 07 July 2014 00:11
By: Michel Cadot
  getting error in a simple collection method
10g
By: harishankar_kar on Sun, 06 July 2014
6 382 Sun, 06 July 2014 10:15
By: BlackSwan
  Conditional Join?
By: sparsh2010 on Sat, 05 July 2014
3 424 Sat, 05 July 2014 13:56
By: Littlefoot
  How to insert data in another table
By: aaditya321 on Wed, 02 July 2014
12 562 Sat, 05 July 2014 02:41
By: aaditya321
  Why we not use out parameter in pl/sql function
By: aaditya321 on Fri, 04 July 2014
6 472 Sat, 05 July 2014 01:47
By: aaditya321
  Generate Graph using PL SQL
By: amit.sonar on Mon, 30 June 2014
22 959 Fri, 04 July 2014 11:15
By: Michel Cadot
  Simultaneous update in child table
By: many_yammy on Thu, 03 July 2014
7 372 Fri, 04 July 2014 01:22
By: John Watson
  Pass sql file as argument in oracle stored procedure/package
10.2.0.4.0
By: grpatwari on Thu, 03 July 2014
11 549 Thu, 03 July 2014 19:48
By: grpatwari
  Processing data from flat files to base files via staging tables
By: CSR24 on Tue, 01 July 2014
10 546 Thu, 03 July 2014 15:19
By: Littlefoot
  Another Hierarchical circular reference question
10.2
By: lott42 on Thu, 03 July 2014
7 288 Thu, 03 July 2014 12:33
By: lott42
  Add sentence if result of string concatenation is too long
Toad for Oracle, v11.6.1.6, Windows 7
By: a415 on Fri, 27 June 2014
8 616 Thu, 03 July 2014 11:20
By: LKBrwn_DBA
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: Sat Dec 20 07:45:46 CST 2014

Total time taken to generate the page: 0.59009 seconds