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-01861: literal does not match format string
Oracle 11g
By: theladyd on Thu, 19 June 2014
4 236 Thu, 19 June 2014 13:21
By: BlackSwan
  ORA-01003: no statement parsed
By: sss111ind on Thu, 19 June 2014
5 224 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 199 Thu, 19 June 2014 07:11
By: Lalit Kumar B
  Help required for Query
Oracle 11g
By: nickz on Tue, 10 June 2014
8 457 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 265 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 307 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 560 Wed, 18 June 2014 07:22
By: Michel Cadot
  How to print vertical numbers
By: aaditya321 on Wed, 18 June 2014
4 308 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 323 Wed, 18 June 2014 02:31
By: rahul1982
  Looping or SQL
Oracle 11g
By: rajivn786 on Tue, 17 June 2014
3 251 Tue, 17 June 2014 19:24
By: Solomon Yakobson
  Reqular expression
Oracle 11.2.0.3
By: pointers on Mon, 16 June 2014
9 461 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 181 Tue, 17 June 2014 09:38
By: BlackSwan
  IN Condition
By: Maverick84 on Mon, 16 June 2014
8 476 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 399 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 228 Tue, 17 June 2014 00:17
By: Littlefoot
  Performance by which cursor is best
By: aaditya321 on Mon, 16 June 2014
5 286 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 314 Mon, 16 June 2014 06:25
By: Michel Cadot
  How to get desire output
By: aaditya321 on Mon, 16 June 2014
10 356 Mon, 16 June 2014 02:49
By: Michel Cadot
  function
ORACLE 11G
By: IRFANMBAIG on Sun, 15 June 2014
4 236 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 286 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 253 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 1525 Fri, 13 June 2014 08:04
By: John Watson
  Select Query
Oracle 10g,Win7 23 bit
By: Xandot on Thu, 12 June 2014
12 428 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 268 Thu, 12 June 2014 09:24
By: Solomon Yakobson
  Create the Sequence
By: vik@s on Thu, 12 June 2014
5 249 Thu, 12 June 2014 08:31
By: Lalit Kumar B
  Dealing with Intervals
Oracle 11gr2
By: bluefred on Mon, 09 June 2014
3 348 Thu, 12 June 2014 03:47
By: bluefred
  SQL Data preparation
11.2.0.3.0
By: grpatwari on Thu, 12 June 2014
7 296 Thu, 12 June 2014 03:46
By: Lalit Kumar B
  Facing Issue with LAST_VALUE function.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Wed, 11 June 2014
28 536 Thu, 12 June 2014 02:00
By: Manoj.Gupta.91
  Purpose of ODCIAggregateMerge
By: user1231 on Thu, 01 May 2014
9 496 Thu, 12 June 2014 00:11
By: arielhhs
  Need School Management Schema
Oracle Developer, Forms 6i, Windows 8
By: azamkhan on Sun, 08 June 2014
18 732 Thu, 12 June 2014 00:11
By: Littlefoot
  Query help with CUBE function
Oracle 11.2.0.4, Linux
By: sspn2010 on Mon, 09 June 2014
6 419 Wed, 11 June 2014 09:45
By: sspn2010
  ORA-01840: input value not long enough for date format
ORACLE 11g
By: jayant.tripathi on Tue, 10 June 2014
5 414 Tue, 10 June 2014 08:24
By: joy_division
  Correlated Sql Query
Oracle 10g,Win7 23 bit
By: Xandot on Mon, 09 June 2014
5 444 Tue, 10 June 2014 07:58
By: Xandot
  what is a nested loop join?
By: mist598 on Tue, 10 June 2014
2 255 Tue, 10 June 2014 07:40
By: Lalit Kumar B
  CREATE TABLE
4.0.2
By: sarahhhh on Sun, 08 June 2014
13 657 Mon, 09 June 2014 04:55
By: flyboy
  pipeline?
By: hahaie on Mon, 09 June 2014
6 338 Mon, 09 June 2014 04:07
By: Lalit Kumar B
  Converting SQL syntax
Oracle 11g R2
By: rchenna on Fri, 06 June 2014
6 336 Fri, 06 June 2014 14:09
By: John Watson
  single query by which data can fetched from table which name generated from a query
oracle 10 g
By: evivekj on Thu, 29 May 2014
13 1082 Fri, 06 June 2014 09:47
By: Michel Cadot
  Cannot access table in PL/SQL even with direct grant
11.2.0.2 Enterprise, RHL
By: d_seng on Fri, 06 June 2014
4 269 Fri, 06 June 2014 06:42
By: EdStevens
  how to use substr while assigning the column & using length function
By: mist598 on Fri, 06 June 2014
4 270 Fri, 06 June 2014 04:04
By: mist598
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 Sep 17 03:12:00 CDT 2014

Total time taken to generate the page: 0.13576 seconds