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
  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 499 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 417 Fri, 11 July 2014 13:06
By: Solomon Yakobson
  to find mid value
pl/sql
By: simplesanju on Wed, 26 February 2014
8 958 Fri, 11 July 2014 07:14
By: jgjeetu
  how to extract hh:mm from timestamp ?
By: tondapi on Thu, 10 July 2014
3 374 Fri, 11 July 2014 02:28
By: Lalit Kumar B
  SQL
By: newastrum on Thu, 10 July 2014
3 405 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 542 Thu, 10 July 2014 08:04
By: Michel Cadot
  pls help in query
pl sql
By: simplesanju on Wed, 19 February 2014
8 794 Thu, 10 July 2014 07:33
By: Roachcoach
  Refcursor with returning resultset
Oracle 10g
By: sss111ind on Tue, 08 July 2014
15 705 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 802 Thu, 10 July 2014 05:15
By: Michel Cadot
  help in sql query
sql
By: simplesanju on Fri, 03 January 2014
5 716 Thu, 10 July 2014 02:33
By: simplesanju
  IN CLAUSE OUTPUT
By: anniepeteroracle on Wed, 09 July 2014
6 561 Thu, 10 July 2014 01:07
By: Michel Cadot
  SQL Group Query
11g
By: tabj on Wed, 09 July 2014
5 568 Wed, 09 July 2014 23:24
By: tabj
  Subquery vs. Join performance (optimizer)
Oracle 11g
By: rc3d on Tue, 08 July 2014
6 517 Wed, 09 July 2014 04:14
By: rc3d
  Packages
10g database, oracle 9i
By: vippysharma on Wed, 09 July 2014
2 371 Wed, 09 July 2014 02:20
By: Michel Cadot
  comparing collections
By: purnima1 on Fri, 04 July 2014
9 690 Wed, 09 July 2014 01:28
By: purnima1
  What is Analytical function?
11g
By: sachinpawar80 on Mon, 07 July 2014
4 563 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 384 Tue, 08 July 2014 06:40
By: EdStevens
  regarding sql query
By: IRFANMBAIG on Tue, 08 July 2014
5 366 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 568 Tue, 08 July 2014 04:37
By: zhaoquer
  ORA-29285: file write error
By: Srini1234 on Tue, 24 May 2005
3 37235 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 557 Mon, 07 July 2014 12:25
By: shumail
  Autocomplete
11g Release 2 Windows
By: Duane on Mon, 07 July 2014
2 272 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 456 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 710 Mon, 07 July 2014 07:19
By: Lalit Kumar B
  what plsqls of this output?
By: hahaie on Sun, 06 July 2014
3 325 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 378 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 630 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 472 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 445 Sun, 06 July 2014 10:15
By: BlackSwan
  Conditional Join?
By: sparsh2010 on Sat, 05 July 2014
3 802 Sat, 05 July 2014 13:56
By: Littlefoot
  How to insert data in another table
By: aaditya321 on Wed, 02 July 2014
12 678 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 553 Sat, 05 July 2014 01:47
By: aaditya321
  Generate Graph using PL SQL
By: amit.sonar on Mon, 30 June 2014
22 1313 Fri, 04 July 2014 11:15
By: Michel Cadot
  Simultaneous update in child table
By: many_yammy on Thu, 03 July 2014
7 416 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 643 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 614 Thu, 03 July 2014 15:19
By: Littlefoot
  Another Hierarchical circular reference question
10.2
By: lott42 on Thu, 03 July 2014
7 317 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 766 Thu, 03 July 2014 11:20
By: LKBrwn_DBA
  Killing job after sometime is not working.
Oracle 11g
By: ramya_162 on Wed, 02 July 2014
6 613 Wed, 02 July 2014 05:03
By: John Watson
  PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
Oracle 11g, 11.2.0.2.0, Windows 7.
By: ho2512 on Wed, 02 July 2014
8 848 Wed, 02 July 2014 04:53
By: ho2512
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: Mon Mar 30 15:27:35 CDT 2015

Total time taken to generate the page: 0.13554 seconds