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
  Days Between Start date/today, unless Date finished.
Application Express 4.1.0.00.32
By: william.wright on Mon, 16 June 2014
2 218 Tue, 17 June 2014 00:17
By: Littlefoot
  Performance by which cursor is best
By: aaditya321 on Mon, 16 June 2014
5 276 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 286 Mon, 16 June 2014 06:25
By: Michel Cadot
  How to get desire output
By: aaditya321 on Mon, 16 June 2014
10 335 Mon, 16 June 2014 02:49
By: Michel Cadot
  function
ORACLE 11G
By: IRFANMBAIG on Sun, 15 June 2014
4 225 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 277 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 235 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 1498 Fri, 13 June 2014 08:04
By: John Watson
  Select Query
Oracle 10g,Win7 23 bit
By: Xandot on Thu, 12 June 2014
12 413 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 251 Thu, 12 June 2014 09:24
By: Solomon Yakobson
  Create the Sequence
By: vik@s on Thu, 12 June 2014
5 227 Thu, 12 June 2014 08:31
By: Lalit Kumar B
  Dealing with Intervals
Oracle 11gr2
By: bluefred on Mon, 09 June 2014
3 330 Thu, 12 June 2014 03:47
By: bluefred
  SQL Data preparation
11.2.0.3.0
By: grpatwari on Thu, 12 June 2014
7 283 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 517 Thu, 12 June 2014 02:00
By: Manoj.Gupta.91
  Purpose of ODCIAggregateMerge
By: user1231 on Thu, 01 May 2014
9 473 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 711 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 391 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 377 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 423 Tue, 10 June 2014 07:58
By: Xandot
  what is a nested loop join?
By: mist598 on Tue, 10 June 2014
2 233 Tue, 10 June 2014 07:40
By: Lalit Kumar B
  CREATE TABLE
4.0.2
By: sarahhhh on Sun, 08 June 2014
13 633 Mon, 09 June 2014 04:55
By: flyboy
  pipeline?
By: hahaie on Mon, 09 June 2014
6 318 Mon, 09 June 2014 04:07
By: Lalit Kumar B
  Converting SQL syntax
Oracle 11g R2
By: rchenna on Fri, 06 June 2014
6 312 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 1060 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 242 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 236 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 347 Fri, 06 June 2014 03:46
By: rahul1982
  SQL QUERY
ORACLE 11G
By: IRFANMBAIG on Sat, 31 May 2014
2 661 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 345 Thu, 05 June 2014 13:45
By: cookiemonster
  Insert with different key values to avoid contraint violation
Oracle 9i
By: lukeskw on Thu, 05 June 2014
8 355 Thu, 05 June 2014 13:36
By: BlackSwan
  Table count with rows and no rows
Oracle 10.2.0.2.0 , windows
By: Jack14 on Wed, 04 June 2014
14 504 Thu, 05 June 2014 05:53
By: Jack14
  Create Sql Query
Oracle 11g,Win7 23 bit
By: Xandot on Thu, 05 June 2014
8 372 Thu, 05 June 2014 04:19
By: Xandot
  How to insert value in a partition table if the partition is not defined.
By: jgjeetu on Thu, 05 June 2014
3 275 Thu, 05 June 2014 00:51
By: jgjeetu
  MySQL to oracle
MySQL 5.1 on centos and oracle 10g on rhel 5.4
By: tejeshrao on Tue, 27 May 2014
26 774 Wed, 04 June 2014 15:43
By: Bill B
  Filter by Count of particular field
By: rlsublime on Mon, 02 June 2014
18 559 Wed, 04 June 2014 12:17
By: Lalit Kumar B
  how to user REGEXP for inserting data from one table to another table
oracle 10g
By: jgjeetu on Wed, 04 June 2014
5 348 Wed, 04 June 2014 01:45
By: Littlefoot
  Invalid Synonym in SQL Plus Vs Toad
Oracle 11g Release 2
By: azeem87 on Tue, 03 June 2014
6 355 Tue, 03 June 2014 13:20
By: Lalit Kumar B
  how to display only char data only or numeric data only not both
By: mist598 on Mon, 02 June 2014
10 651 Tue, 03 June 2014 01:28
By: mist598
  How to partition Table Data Alphabetically
By: jgjeetu on Sat, 31 May 2014
12 584 Sun, 01 June 2014 15:01
By: EdStevens
  about excute procedure
By: man silence on Fri, 30 May 2014
3 265 Fri, 30 May 2014 15:09
By: man silence
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 02 08:37:54 CDT 2014

Total time taken to generate the page: 0.24027 seconds