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
  ORA-01031: insufficient privileges
Oracle Database 11g Release 11.2.0.1.0 - Production
By: mokarem on Tue, 11 November 2014
6 223 Wed, 12 November 2014 00:17
By: mokarem
  Conditional INSERT
11g
By: shree_z on Mon, 10 November 2014
4 231 Tue, 11 November 2014 14:07
By: Bill B
  date validation
date validation
By: sanodani on Tue, 11 November 2014
6 219 Tue, 11 November 2014 13:43
By: sanodani
  Can I call a stored procedure through a select query
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: queeny on Mon, 10 November 2014
6 331 Tue, 11 November 2014 13:41
By: cookiemonster
  Long and Clob Problem
win 8,Oracle Forms 6i,Oracle 10g
By: Xandot on Tue, 11 November 2014
6 191 Tue, 11 November 2014 08:56
By: Xandot
  Buffer size error from External table
Oracle Database 11g Release 11.2.0.1.0 - Production
By: mokarem on Mon, 10 November 2014
3 244 Tue, 11 November 2014 00:42
By: Michel Cadot
  Oracle-Should I use temp table or ref cursor
Oracle 11g
By: sormita on Wed, 05 November 2014
5 365 Mon, 10 November 2014 17:12
By: CraigB
  log_table
By: sanodani on Mon, 10 November 2014
10 434 Mon, 10 November 2014 15:49
By: joy_division
  Delayed update to global variable via pipelined function?
Oracle DB 10g 10.2.0.4.0
By: GHott on Mon, 10 November 2014
4 206 Mon, 10 November 2014 15:01
By: GHott
  Pick random rows
11g
By: shree_z on Fri, 07 November 2014
15 362 Mon, 10 November 2014 14:25
By: shree_z
  Regular Expression ( REGEXP) not working with Oracle 10.2.0.4.0
Oracle 10.2.0.4.0
By: nadeemzones on Mon, 10 November 2014
1 178 Mon, 10 November 2014 04:32
By: Michel Cadot
  UTL_HTTP help
Oracle DB 11gR2
By: leeweb on Fri, 07 November 2014
7 318 Mon, 10 November 2014 03:20
By: leeweb
  Distribution of values/data in hash subpartition
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 07 November 2014
10 355 Mon, 10 November 2014 02:56
By: John Watson
  Conver SYBASE to Oracle
By: mokarem on Sun, 09 November 2014
4 209 Mon, 10 November 2014 02:29
By: Michel Cadot
  list of columns of a table
By: hahaie on Mon, 10 November 2014
3 204 Mon, 10 November 2014 00:28
By: hahaie
  NESTED COLLECTIONS
Oracle 11g
By: vicktorz on Sat, 08 November 2014
10 334 Sun, 09 November 2014 10:56
By: Solomon Yakobson
  SQL Case statement with Regular Expression
Oracle 11g
By: queeny on Sun, 09 November 2014
1 186 Sun, 09 November 2014 09:13
By: BlackSwan
  EXECUTE IMMEDIATE trowing an error in PL/SQL Block
oracle 11g R2 WIN 7
By: 9390512774 on Fri, 07 November 2014
6 235 Sat, 08 November 2014 01:32
By: John Watson
  SQL Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, Centos 5
By: Raakh on Tue, 04 November 2014
27 667 Fri, 07 November 2014 07:54
By: Raakh
  How to get the result for my query
By: venki459 on Thu, 06 November 2014
9 300 Fri, 07 November 2014 06:35
By: EdStevens
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
3 191 Fri, 07 November 2014 03:30
By: Michel Cadot
  Table Creation using WITH Clause
oracle 11g R2 WIN 7
By: 9390512774 on Thu, 06 November 2014
4 214 Fri, 07 November 2014 03:19
By: sandeep_orafaq
  What is the limitation in number of parameters in oracle stored procedure and function?
By: Jothish on Fri, 07 November 2014
1 146 Fri, 07 November 2014 02:15
By: John Watson
  split clob into rows
Oracle 11g
By: mape on Thu, 06 November 2014
5 185 Thu, 06 November 2014 12:43
By: mape
icon5.gif ORA-01427: single-row subquery returns more than one row
By: hunterakishou on Thu, 06 November 2014
4 212 Thu, 06 November 2014 12:19
By: hunterakishou
  how do associate array working
By: mist598 on Thu, 06 November 2014
4 260 Thu, 06 November 2014 10:10
By: Solomon Yakobson
  insert data
oracle 11g
By: thelearner on Wed, 05 November 2014
13 398 Thu, 06 November 2014 07:54
By: Lalit Kumar B
  how to convert code of sql server into oracle
By: aaditya321 on Wed, 05 November 2014
6 323 Wed, 05 November 2014 16:07
By: Michel Cadot
  One Single Stored Procedure to fetch data using multiple complex queries
Oracle
By: contactsenthils@yahoo.com on Tue, 28 October 2014
2 318 Wed, 05 November 2014 10:58
By: raj_te
  trigger on update
By: mist598 on Wed, 05 November 2014
6 274 Wed, 05 November 2014 08:40
By: Michel Cadot
  how to handle zero divide error in formula calculation
By: venki459 on Sun, 02 November 2014
16 807 Wed, 05 November 2014 01:08
By: m.abdulhaq
  Data migration
By: NewToOracle10g on Sun, 02 November 2014
11 483 Wed, 05 November 2014 00:46
By: Michel Cadot
  Change the Data type of non empty column
Oracle 11g
By: Xandot on Tue, 04 November 2014
7 304 Tue, 04 November 2014 08:06
By: Lalit Kumar B
  Modify unique index to non-unique index without dropping index
Oracle 11.2.0.3.0 - 64bit
By: avineshr on Sun, 02 November 2014
5 395 Sun, 02 November 2014 22:45
By: Kevin Meade
  ORA-12012 ORA-01031 ORA-06512
oracle 11.2.0.4
By: ganesh_gvn on Sat, 01 November 2014
6 314 Sun, 02 November 2014 22:44
By: Kevin Meade
  Hierarchy problem
11.2.0.3
By: Amine on Mon, 27 October 2014
6 459 Sun, 02 November 2014 01:22
By: Michel Cadot
  Please clarify the LOCK doubts
Oracle 11g
By: ramya_162 on Sat, 01 November 2014
2 314 Sat, 01 November 2014 07:08
By: EdStevens
  FOR UPDATE OF not working
oracle 10g
By: vivek_rol on Fri, 31 October 2014
14 390 Fri, 31 October 2014 11:01
By: Michel Cadot
  Transforming rows to colums
Oracle, 10g
By: MeRamki on Thu, 30 October 2014
11 394 Fri, 31 October 2014 04:36
By: sandeep_orafaq
  Calling Shell script from pl/sql procedure
11g R2, Linux(unix)
By: srinivas.k2005 on Thu, 30 October 2014
2 496 Thu, 30 October 2014 11:39
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: Wed Dec 17 17:27:03 CST 2014

Total time taken to generate the page: 0.14763 seconds