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
  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 540 Thu, 12 June 2014 02:00
By: Manoj.Gupta.91
  Purpose of ODCIAggregateMerge
By: user1231 on Thu, 01 May 2014
9 498 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 735 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 426 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 418 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 449 Tue, 10 June 2014 07:58
By: Xandot
  what is a nested loop join?
By: mist598 on Tue, 10 June 2014
2 260 Tue, 10 June 2014 07:40
By: Lalit Kumar B
  CREATE TABLE
4.0.2
By: sarahhhh on Sun, 08 June 2014
13 659 Mon, 09 June 2014 04:55
By: flyboy
  pipeline?
By: hahaie on Mon, 09 June 2014
6 340 Mon, 09 June 2014 04:07
By: Lalit Kumar B
  Converting SQL syntax
Oracle 11g R2
By: rchenna on Fri, 06 June 2014
6 337 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 1087 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 274 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 272 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 376 Fri, 06 June 2014 03:46
By: rahul1982
  SQL QUERY
ORACLE 11G
By: IRFANMBAIG on Sat, 31 May 2014
2 691 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 375 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 382 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 534 Thu, 05 June 2014 05:53
By: Jack14
  Create Sql Query
Oracle 11g,Win7 23 bit
By: Xandot on Thu, 05 June 2014
8 398 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 293 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 803 Wed, 04 June 2014 15:43
By: Bill B
  Filter by Count of particular field
By: rlsublime on Mon, 02 June 2014
18 583 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 377 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 373 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 672 Tue, 03 June 2014 01:28
By: mist598
  How to partition Table Data Alphabetically
By: jgjeetu on Sat, 31 May 2014
12 612 Sun, 01 June 2014 15:01
By: EdStevens
  about excute procedure
By: man silence on Fri, 30 May 2014
3 289 Fri, 30 May 2014 15:09
By: man silence
  Replace all substrings by another strings
Ora 11g
By: slaguila on Thu, 29 May 2014
9 616 Fri, 30 May 2014 08:49
By: Solomon Yakobson
  how to write an excel in PLSQL
By: evivekj on Thu, 29 May 2014
17 765 Fri, 30 May 2014 08:24
By: cookiemonster
  How to add partition by list clause on existing empty table
oracle 10g
By: jgjeetu on Fri, 30 May 2014
4 1371 Fri, 30 May 2014 06:54
By: jgjeetu
  Spliting string more than 32767 characters
Oracle 10g
By: sss111ind on Thu, 29 May 2014
3 285 Fri, 30 May 2014 02:35
By: Michel Cadot
  Using SQL in pass through query in Access to Oracle
Windows 7, Oracle 11.0.0.116
By: ipisors on Wed, 28 May 2014
5 349 Thu, 29 May 2014 15:18
By: ipisors
  Need Design input to execute store proc
ORACLE 11g
By: gorants on Wed, 28 May 2014
6 393 Thu, 29 May 2014 13:50
By: Michel Cadot
  Delete getting stuck
11g Release 2
By: azeem87 on Mon, 05 May 2014
37 1291 Thu, 29 May 2014 12:44
By: BlackSwan
  Need help in this SQL logic
Oracle 11g
By: vishalshinde.2004 on Thu, 29 May 2014
6 367 Thu, 29 May 2014 06:51
By: Solomon Yakobson
  Adding column to existing index
Oracle 11
By: brown_zzz on Thu, 29 May 2014
1 188 Thu, 29 May 2014 06:44
By: Lalit Kumar B
  View on synonym
oracle 10.2.0.4 - Windows server 2003
By: muktha_22 on Thu, 29 May 2014
7 312 Thu, 29 May 2014 06:08
By: Lalit Kumar B
  multiple values in a single column should be populated as multiple rows
oracle 11g
By: vkanuri on Wed, 28 May 2014
1 284 Wed, 28 May 2014 14:14
By: Michel Cadot
icon5.gif re-raising the exception.
oracle 11g , Hp UNIX
By: live4learn on Tue, 27 May 2014
9 424 Wed, 28 May 2014 09:57
By: Lalit Kumar B
  ORA-03113: end-of-file on communication channel
By: sibashishnayak on Wed, 28 May 2014
1 243 Wed, 28 May 2014 03:18
By: Michel Cadot
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 22:51:07 CDT 2014

Total time taken to generate the page: 0.10093 seconds