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 for Query
Oracle 11g
By: nickz on Tue, 10 June 2014
8 407 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 233 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 276 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 531 Wed, 18 June 2014 07:22
By: Michel Cadot
  How to print vertical numbers
By: aaditya321 on Wed, 18 June 2014
4 287 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 292 Wed, 18 June 2014 02:31
By: rahul1982
  Looping or SQL
Oracle 11g
By: rajivn786 on Tue, 17 June 2014
3 219 Tue, 17 June 2014 19:24
By: Solomon Yakobson
  Reqular expression
Oracle 11.2.0.3
By: pointers on Mon, 16 June 2014
9 422 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 129 Tue, 17 June 2014 09:38
By: BlackSwan
  IN Condition
By: Maverick84 on Mon, 16 June 2014
8 439 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 362 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 193 Tue, 17 June 2014 00:17
By: Littlefoot
  Performance by which cursor is best
By: aaditya321 on Mon, 16 June 2014
5 261 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 252 Mon, 16 June 2014 06:25
By: Michel Cadot
  How to get desire output
By: aaditya321 on Mon, 16 June 2014
10 314 Mon, 16 June 2014 02:49
By: Michel Cadot
  function
ORACLE 11G
By: IRFANMBAIG on Sun, 15 June 2014
4 209 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 259 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 210 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 1465 Fri, 13 June 2014 08:04
By: John Watson
  Select Query
Oracle 10g,Win7 23 bit
By: Xandot on Thu, 12 June 2014
12 395 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 228 Thu, 12 June 2014 09:24
By: Solomon Yakobson
  Create the Sequence
By: vik@s on Thu, 12 June 2014
5 204 Thu, 12 June 2014 08:31
By: Lalit Kumar B
  Dealing with Intervals
Oracle 11gr2
By: bluefred on Mon, 09 June 2014
3 306 Thu, 12 June 2014 03:47
By: bluefred
  SQL Data preparation
11.2.0.3.0
By: grpatwari on Thu, 12 June 2014
7 267 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 487 Thu, 12 June 2014 02:00
By: Manoj.Gupta.91
  Purpose of ODCIAggregateMerge
By: user1231 on Thu, 01 May 2014
9 447 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 673 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 363 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 334 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 400 Tue, 10 June 2014 07:58
By: Xandot
  what is a nested loop join?
By: mist598 on Tue, 10 June 2014
2 217 Tue, 10 June 2014 07:40
By: Lalit Kumar B
  CREATE TABLE
4.0.2
By: sarahhhh on Sun, 08 June 2014
13 605 Mon, 09 June 2014 04:55
By: flyboy
  pipeline?
By: hahaie on Mon, 09 June 2014
6 303 Mon, 09 June 2014 04:07
By: Lalit Kumar B
  Converting SQL syntax
Oracle 11g R2
By: rchenna on Fri, 06 June 2014
6 276 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 1040 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 215 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 207 Fri, 06 June 2014 04:04
By: mist598
  column header needs to add for each record
Oracle 11g, Linux
By: rahul1982 on Thu, 05 June 2014
5 331 Fri, 06 June 2014 03:46
By: rahul1982
  SQL QUERY
ORACLE 11G
By: IRFANMBAIG on Sat, 31 May 2014
2 631 Thu, 05 June 2014 15:02
By: vemulapalli.satish83
  Left outer Join nt working as desired
Oracle 11g
By: raj_te on Thu, 05 June 2014
6 323 Thu, 05 June 2014 13:45
By: cookiemonster
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 Jul 31 17:29:51 CDT 2014

Total time taken to generate the page: 0.13724 seconds