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 with pre 9i Join to ANSI standard
11, UNIX
By: sucheta on Tue, 30 September 2014
14 627 Wed, 01 October 2014 03:45
By: cookiemonster
  group by to_char resulting in Exception: ORA-00979: not a GROUP BY expression
OEM 12C
By: vjeedigunta on Mon, 29 September 2014
4 435 Tue, 30 September 2014 02:22
By: Lalit Kumar B
  ORA-12704: character set mismatch
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit, MS WINDOWS Server 2008
By: shahrir83 on Tue, 30 September 2014
1 612 Tue, 30 September 2014 02:20
By: Michel Cadot
  distribute grp_cd equally among the data
By: rkhatiwala on Fri, 26 September 2014
3 379 Mon, 29 September 2014 22:49
By: Lalit Kumar B
  Help WIth Fixing Errors In SQL Script
SQL Plus
By: Mckenzo101 on Sat, 27 September 2014
6 560 Mon, 29 September 2014 13:18
By: Bill B
  Regexp Replace - Replacement Problem
By: wintech on Sun, 28 September 2014
2 355 Sun, 28 September 2014 13:51
By: wintech
  Error with multi-dimenssional array.
By: amit.sonar on Thu, 25 September 2014
3 395 Sun, 28 September 2014 13:31
By: amit.sonar
  PLS-00306: wrong number or types of arguments in call to 'PR_4552'
Oralce 11g
By: na.dharma@gmail.com on Wed, 30 April 2014
11 931 Sat, 27 September 2014 13:39
By: pablolee
  Package of Analyze Partitions
Oracle 11R2
By: loupstr on Thu, 25 September 2014
6 468 Fri, 26 September 2014 16:12
By: CraigB
  Question about v$version
Oracle 10,11
By: lott42 on Fri, 26 September 2014
6 438 Fri, 26 September 2014 15:30
By: lott42
  stored procedure
oracle 10g
By: simplesanju on Fri, 26 September 2014
2 366 Fri, 26 September 2014 06:08
By: simplesanju
  Add # of days and then pass it as a variable
Oracle 11g release 2
By: azeem87 on Thu, 25 September 2014
5 433 Thu, 25 September 2014 14:56
By: azeem87
  order by query in sql
11g
By: haadiya on Thu, 25 September 2014
16 650 Thu, 25 September 2014 14:55
By: Bill B
  Unique constraint error
Oracle 11.2.0.2 G
By: aishvarya.singh on Thu, 25 September 2014
7 387 Thu, 25 September 2014 10:41
By: flyboy
  FOR UPDATE clause
ERP
By: chat2raj.s on Thu, 25 September 2014
4 386 Thu, 25 September 2014 10:41
By: sandeep_orafaq
  Need Sql query
By: mvrkr44 on Thu, 25 September 2014
9 466 Thu, 25 September 2014 05:58
By: pablolee
  Help on a query
By: lovelysethii@gmail.com on Wed, 24 September 2014
8 565 Thu, 25 September 2014 04:39
By: lovelysethii@gmail.com
  Row generator
Oracle 10.2
By: m.abdulhaq on Wed, 24 September 2014
10 506 Thu, 25 September 2014 01:17
By: m.abdulhaq
  Questing regarding level and connect by
Oracle 10g
By: akull on Tue, 23 September 2014
9 863 Thu, 25 September 2014 00:31
By: jgjeetu
  User Login Query for Specific Month
Oracle Database 11.2.0.3.0 IBM AIX 6.1
By: wtolentino on Wed, 24 September 2014
20 597 Wed, 24 September 2014 14:02
By: Michel Cadot
  DECODE not working the way expected
Oracle 10g
By: chof on Tue, 23 September 2014
9 484 Wed, 24 September 2014 10:13
By: chof
  Need Materialised view
By: mvrkr44 on Wed, 24 September 2014
2 335 Wed, 24 September 2014 06:54
By: Lalit Kumar B
  minus operator question
By: ora1980 on Tue, 23 September 2014
8 748 Tue, 23 September 2014 14:54
By: Michel Cadot
  BACKUP PACKAGES
By: hahaie on Tue, 23 September 2014
3 461 Tue, 23 September 2014 14:29
By: BlackSwan
  Alternate of UNION ALL
Oracle 10G , Windows 7
By: adilsami on Tue, 23 September 2014
18 574 Tue, 23 September 2014 12:47
By: Michel Cadot
  which column to have index
Linux, Oracle 11.2.0.2.0
By: rahul1982 on Mon, 22 September 2014
7 486 Tue, 23 September 2014 08:57
By: Lalit Kumar B
  Query to find duplicate rows from table
By: gaganmadhu on Tue, 23 September 2014
6 549 Tue, 23 September 2014 08:42
By: Michel Cadot
  what is the issue in my query
Toad 10.6.1
By: lvrvln on Sun, 21 September 2014
6 428 Tue, 23 September 2014 06:44
By: Lalit Kumar B
  Data in AM/PM
By: kr1347 on Mon, 22 September 2014
4 350 Mon, 22 September 2014 14:42
By: Michel Cadot
  Unable to drop a column in table.
Oracle 12c, Windows
By: nmdivya@gmail.com on Mon, 22 September 2014
12 892 Mon, 22 September 2014 13:26
By: EdStevens
  Please solve my issue
By: aaditya321 on Sat, 20 September 2014
19 2656 Mon, 22 September 2014 13:06
By: Solomon Yakobson
  mutating trigger
oracle 11g r2
By: guddu_12 on Mon, 22 September 2014
6 626 Mon, 22 September 2014 11:53
By: John Watson
  Reference for values in SYS.AUD$.STATEMENTID
11.2.0.1
By: youngryand on Mon, 22 September 2014
4 406 Mon, 22 September 2014 10:42
By: Lalit Kumar B
  Multiple Records in single xml with compound trigger
By: shannu on Sat, 20 September 2014
2 362 Sat, 20 September 2014 09:35
By: BlackSwan
  Table LOCK in PeopleSoft Program
Oracle SQL
By: gaganmadhu on Fri, 19 September 2014
3 2348 Fri, 19 September 2014 14:22
By: Michel Cadot
  Doubt on REGEXP_LIKE
Oracle 11g
By: na.dharma@gmail.com on Fri, 19 September 2014
11 2260 Fri, 19 September 2014 11:18
By: Lalit Kumar B
  Doubt on Substr
Oralce 11g
By: na.dharma@gmail.com on Fri, 19 September 2014
1 322 Fri, 19 September 2014 05:26
By: Lalit Kumar B
  SQL Joins
Oracle 11g
By: srinivas.k2005 on Thu, 18 September 2014
17 722 Fri, 19 September 2014 00:06
By: srinivas.k2005
  Question on Trace file
11g
By: andrewscharles89 on Thu, 18 September 2014
4 324 Thu, 18 September 2014 15:09
By: joy_division
  Query to get highest date id's
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, Linux
By: anil_mk on Wed, 17 September 2014
18 647 Thu, 18 September 2014 13:59
By: anil_mk
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 Mar 31 04:12:43 CDT 2015

Total time taken to generate the page: 0.10927 seconds