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
  assertions
sql
By: ghostrider on Fri, 08 February 2013
13 1109 Mon, 23 June 2014 07:11
By: John Watson
  Procedure to read mails from mailbox and insert into table
oracle 11.2.0.1.0 windows XP
By: kavirajd on Mon, 23 June 2014
2 219 Mon, 23 June 2014 04:07
By: Lalit Kumar B
  Sys_refcursor
By: Rarawshenkiv on Thu, 20 February 2014
3 407 Mon, 23 June 2014 01:10
By: Barbara Boehmer
  sysdate functioning
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
5 395 Sun, 22 June 2014 12:49
By: Lalit Kumar B
  Getting duplicate entry in audit table after triggered
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
4 282 Sun, 22 June 2014 04:59
By: dariyoosh
  Table Design Consideration
By: VIP2013 on Sat, 21 June 2014
17 580 Sat, 21 June 2014 15:29
By: VIP2013
  create sequence within pl/sql execute immediate.
By: laksha on Fri, 10 November 2006
4 12301 Sat, 21 June 2014 12:23
By: Lalit Kumar B
  PARALLEL hint is not working in 11g.
By: M. Salman Sabir on Fri, 20 June 2014
4 383 Sat, 21 June 2014 10:04
By: John Watson
  cursor is not working
By: aaditya321 on Sat, 21 June 2014
8 462 Sat, 21 June 2014 08:17
By: Michel Cadot
  doubt regarding exception handling?
11g
By: kiranrathodkr916 on Fri, 20 June 2014
15 515 Fri, 20 June 2014 15:33
By: Michel Cadot
  SYSDATE Central to Eastern time
Oracle 11gR2 11.2.0.4
By: kvignes1 on Fri, 20 June 2014
11 383 Fri, 20 June 2014 14:31
By: EdStevens
  Multibyte character
Oracle 11G
By: elaiyavel on Thu, 19 June 2014
11 528 Fri, 20 June 2014 09:06
By: Lalit Kumar B
  SQL or loops
Oracle 11g
By: rajivn786 on Wed, 18 June 2014
18 560 Thu, 19 June 2014 17:24
By: rajivn786
  ORA-01861: literal does not match format string
Oracle 11g
By: theladyd on Thu, 19 June 2014
4 241 Thu, 19 June 2014 13:21
By: BlackSwan
  ORA-01003: no statement parsed
By: sss111ind on Thu, 19 June 2014
5 227 Thu, 19 June 2014 08:59
By: sss111ind
  how to add mautiple partition on a table.
oracle 10g
By: jgjeetu on Thu, 19 June 2014
2 207 Thu, 19 June 2014 07:11
By: Lalit Kumar B
  Help required for Query
Oracle 11g
By: nickz on Tue, 10 June 2014
8 461 Thu, 19 June 2014 05:50
By: Michel Cadot
  How to add new partition on a table if Default partition is existing
oracle 10g
By: jgjeetu on Wed, 18 June 2014
5 272 Thu, 19 June 2014 05:48
By: Michel Cadot
  How to disable any command for user who has full rights
By: jgjeetu on Tue, 17 June 2014
5 309 Wed, 18 June 2014 08:23
By: Lalit Kumar B
  DBMS_JOB: Numerous jobs
DB 11.2.0.1.0, Windows server 2008 R2
By: ibergo on Thu, 15 May 2014
13 564 Wed, 18 June 2014 07:22
By: Michel Cadot
  How to print vertical numbers
By: aaditya321 on Wed, 18 June 2014
4 310 Wed, 18 June 2014 05:26
By: Michel Cadot
  create separate record for each column
Oracle 11g, Linux
By: rahul1982 on Tue, 17 June 2014
4 325 Wed, 18 June 2014 02:31
By: rahul1982
  Looping or SQL
Oracle 11g
By: rajivn786 on Tue, 17 June 2014
3 253 Tue, 17 June 2014 19:24
By: Solomon Yakobson
  Reqular expression
Oracle 11.2.0.3
By: pointers on Mon, 16 June 2014
9 463 Tue, 17 June 2014 10:44
By: Solomon Yakobson
  ORA-06502: PL/SQL: numeric or value error in xmltype.getClobVal
Oracle 10g
By: rk_0711 on Tue, 17 June 2014
1 184 Tue, 17 June 2014 09:38
By: BlackSwan
  IN Condition
By: Maverick84 on Mon, 16 June 2014
8 477 Tue, 17 June 2014 04:44
By: cookiemonster
  output of a refcursor which is inside a loop
Oracle 11g
By: ashish_2005 on Mon, 16 June 2014
14 405 Tue, 17 June 2014 04:08
By: Lalit Kumar B
  Days Between Start date/today, unless Date finished.
Application Express 4.1.0.00.32
By: william.wright on Mon, 16 June 2014
2 230 Tue, 17 June 2014 00:17
By: Littlefoot
  Performance by which cursor is best
By: aaditya321 on Mon, 16 June 2014
5 287 Mon, 16 June 2014 07:03
By: Lalit Kumar B
  how to recover data in case of truncate table and drop partition
By: jgjeetu on Mon, 16 June 2014
7 315 Mon, 16 June 2014 06:25
By: Michel Cadot
  How to get desire output
By: aaditya321 on Mon, 16 June 2014
10 359 Mon, 16 June 2014 02:49
By: Michel Cadot
  function
ORACLE 11G
By: IRFANMBAIG on Sun, 15 June 2014
4 240 Sun, 15 June 2014 12:16
By: Littlefoot
  Like with CLOB
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Sat, 14 June 2014
5 290 Sun, 15 June 2014 05:34
By: Michel Cadot
  Delete statement is taking long time. Please suggest.
oracle 11g
By: somnathsikdar on Fri, 13 June 2014
2 254 Fri, 13 June 2014 08:58
By: Lalit Kumar B
  how to remove dots in the column ( 1 2)
By: mist598 on Wed, 11 June 2014
61 1528 Fri, 13 June 2014 08:04
By: John Watson
  Select Query
Oracle 10g,Win7 23 bit
By: Xandot on Thu, 12 June 2014
12 429 Fri, 13 June 2014 05:12
By: Littlefoot
  oracle package referring old schema after migration to new schema
oracle 11g
By: Shravan48 on Thu, 12 June 2014
5 271 Thu, 12 June 2014 09:24
By: Solomon Yakobson
  Create the Sequence
By: vik@s on Thu, 12 June 2014
5 252 Thu, 12 June 2014 08:31
By: Lalit Kumar B
  Dealing with Intervals
Oracle 11gr2
By: bluefred on Mon, 09 June 2014
3 352 Thu, 12 June 2014 03:47
By: bluefred
  SQL Data preparation
11.2.0.3.0
By: grpatwari on Thu, 12 June 2014
7 297 Thu, 12 June 2014 03:46
By: Lalit Kumar B
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: Thu Sep 18 19:17:28 CDT 2014

Total time taken to generate the page: 0.10460 seconds