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
  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
  how to recover data from clob
Oracle 11g
By: zhaoquer on Wed, 02 July 2014
14 457 Tue, 08 July 2014 04:37
By: zhaoquer
  ORA-29285: file write error
By: Srini1234 on Tue, 24 May 2005
3 36497 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 481 Mon, 07 July 2014 12:25
By: shumail
  Autocomplete
11g Release 2 Windows
By: Duane on Mon, 07 July 2014
2 248 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 353 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 541 Mon, 07 July 2014 07:19
By: Lalit Kumar B
  what plsqls of this output?
By: hahaie on Sun, 06 July 2014
3 283 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 304 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 511 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 424 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 364 Sun, 06 July 2014 10:15
By: BlackSwan
  Conditional Join?
By: sparsh2010 on Sat, 05 July 2014
3 407 Sat, 05 July 2014 13:56
By: Littlefoot
  How to insert data in another table
By: aaditya321 on Wed, 02 July 2014
12 550 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 458 Sat, 05 July 2014 01:47
By: aaditya321
  Generate Graph using PL SQL
By: amit.sonar on Mon, 30 June 2014
22 891 Fri, 04 July 2014 11:15
By: Michel Cadot
  Simultaneous update in child table
By: many_yammy on Thu, 03 July 2014
7 356 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 518 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 532 Thu, 03 July 2014 15:19
By: Littlefoot
  Another Hierarchical circular reference question
10.2
By: lott42 on Thu, 03 July 2014
7 280 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 569 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 452 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 527 Wed, 02 July 2014 04:53
By: ho2512
  Grouped data on detail record
10g
By: RM33 on Tue, 01 July 2014
3 342 Wed, 02 July 2014 01:47
By: John Watson
  DBMS_LOB defined in a View - Error: ORA-01031: insufficient privileges
Oracle 11g
By: sivakumar121 on Tue, 01 July 2014
1 242 Tue, 01 July 2014 04:47
By: Michel Cadot
  CURSOR FOR LOOP
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Fri, 27 June 2014
4 470 Mon, 30 June 2014 21:46
By: manubatham20
  Data extract from scheduled process improvement
By: ramraju20000 on Sun, 29 June 2014
5 421 Mon, 30 June 2014 15:33
By: Bill B
  Display output like.
By: vik@s on Tue, 24 June 2014
12 657 Mon, 30 June 2014 15:28
By: Bill B
  >= date field in Oracle not retrieving expected results (merged 2 by MC)
Oracle Database 10g Release 10.2.0.3.0 - Production
By: ipisors on Mon, 30 June 2014
3 338 Mon, 30 June 2014 11:42
By: ipisors
  SELECT grant on view to a role.
Oracle 11G
By: sinpeak on Mon, 30 June 2014
4 332 Mon, 30 June 2014 06:38
By: Solomon Yakobson
  Sort data output to excel (owa_util) from 2 cursor
By: aryanna on Wed, 05 March 2014
2 475 Fri, 27 June 2014 18:03
By: Barbara Boehmer
  input argument in function use in select statement
By: Anjas_DA on Fri, 27 June 2014
10 408 Fri, 27 June 2014 12:32
By: flyboy
  find all the null data value in column
oracle 11gr2
By: guddu_12 on Fri, 27 June 2014
4 345 Fri, 27 June 2014 07:38
By: guddu_12
  SQL query to use Reg_exp
Oracle 10g/11g
By: dorerajp on Thu, 26 June 2014
12 472 Fri, 27 June 2014 07:12
By: Solomon Yakobson
  How to enforce key uniqueness in a temporal table?
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: SeanBDurkin on Wed, 25 June 2014
8 457 Thu, 26 June 2014 16:13
By: DrabJay
  How to find primary key ,foreign key , index and sequence associated to a table
By: gorants on Thu, 26 June 2014
2 334 Thu, 26 June 2014 11:42
By: BlackSwan
  Incorrect number of seconds returned from function
Oracle 11g R2
By: PeterS on Wed, 25 June 2014
6 353 Thu, 26 June 2014 04:54
By: Solomon Yakobson
  Oracle function/package same as SAS spedis function
Oracle 11g, Linux
By: rahul1982 on Thu, 26 June 2014
4 478 Thu, 26 June 2014 03:02
By: pablolee
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 05:40:04 CST 2014

Total time taken to generate the page: 0.06910 seconds