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
  Help Required in SQL Analytic Function.
Oracle 11gR2, 11.2.0.1.0, RHEL 5.0
By: jimit_shaili on Sat, 14 June 2014
26 1096 Tue, 24 June 2014 00:18
By: Michel Cadot
  Exchange partition from table at remote database
By: purnima1 on Thu, 19 June 2014
16 618 Tue, 24 June 2014 00:02
By: Lalit Kumar B
  convert char to date
Oracle 11g
By: mape on Sat, 21 June 2014
5 561 Mon, 23 June 2014 08:10
By: cookiemonster
  assertions
sql
By: ghostrider on Fri, 08 February 2013
13 1132 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 231 Mon, 23 June 2014 04:07
By: Lalit Kumar B
  Sys_refcursor
By: Rarawshenkiv on Thu, 20 February 2014
3 433 Mon, 23 June 2014 01:10
By: Barbara Boehmer
  sysdate functioning
Oracle DB 10g
By: aruntutor on Sun, 22 June 2014
5 413 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 298 Sun, 22 June 2014 04:59
By: dariyoosh
  Table Design Consideration
By: VIP2013 on Sat, 21 June 2014
17 602 Sat, 21 June 2014 15:29
By: VIP2013
  create sequence within pl/sql execute immediate.
By: laksha on Fri, 10 November 2006
4 12350 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 410 Sat, 21 June 2014 10:04
By: John Watson
  cursor is not working
By: aaditya321 on Sat, 21 June 2014
8 490 Sat, 21 June 2014 08:17
By: Michel Cadot
  doubt regarding exception handling?
11g
By: kiranrathodkr916 on Fri, 20 June 2014
15 543 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 424 Fri, 20 June 2014 14:31
By: EdStevens
  Multibyte character
Oracle 11G
By: elaiyavel on Thu, 19 June 2014
11 560 Fri, 20 June 2014 09:06
By: Lalit Kumar B
  SQL or loops
Oracle 11g
By: rajivn786 on Wed, 18 June 2014
18 581 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 262 Thu, 19 June 2014 13:21
By: BlackSwan
  ORA-01003: no statement parsed
By: sss111ind on Thu, 19 June 2014
5 246 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 230 Thu, 19 June 2014 07:11
By: Lalit Kumar B
  Help required for Query
Oracle 11g
By: nickz on Tue, 10 June 2014
8 482 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 294 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 332 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 584 Wed, 18 June 2014 07:22
By: Michel Cadot
  How to print vertical numbers
By: aaditya321 on Wed, 18 June 2014
4 333 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 344 Wed, 18 June 2014 02:31
By: rahul1982
  Looping or SQL
Oracle 11g
By: rajivn786 on Tue, 17 June 2014
3 276 Tue, 17 June 2014 19:24
By: Solomon Yakobson
  Reqular expression
Oracle 11.2.0.3
By: pointers on Mon, 16 June 2014
9 486 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 205 Tue, 17 June 2014 09:38
By: BlackSwan
  IN Condition
By: Maverick84 on Mon, 16 June 2014
8 497 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 429 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 250 Tue, 17 June 2014 00:17
By: Littlefoot
  Performance by which cursor is best
By: aaditya321 on Mon, 16 June 2014
5 307 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 340 Mon, 16 June 2014 06:25
By: Michel Cadot
  How to get desire output
By: aaditya321 on Mon, 16 June 2014
10 379 Mon, 16 June 2014 02:49
By: Michel Cadot
  function
ORACLE 11G
By: IRFANMBAIG on Sun, 15 June 2014
4 251 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 298 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 264 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 1549 Fri, 13 June 2014 08:04
By: John Watson
  Select Query
Oracle 10g,Win7 23 bit
By: Xandot on Thu, 12 June 2014
12 441 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 290 Thu, 12 June 2014 09:24
By: Solomon Yakobson
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: Tue Sep 30 17:55:34 CDT 2014

Total time taken to generate the page: 0.25209 seconds