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
  Add # of days and then pass it as a variable
Oracle 11g release 2
By: azeem87 on Thu, 25 September 2014
5 454 Thu, 25 September 2014 14:56
By: azeem87
  order by query in sql
11g
By: haadiya on Thu, 25 September 2014
16 660 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 395 Thu, 25 September 2014 10:41
By: flyboy
  FOR UPDATE clause
ERP
By: chat2raj.s on Thu, 25 September 2014
4 394 Thu, 25 September 2014 10:41
By: sandeep_orafaq
  Need Sql query
By: mvrkr44 on Thu, 25 September 2014
9 473 Thu, 25 September 2014 05:58
By: pablolee
  Help on a query
By: lovelysethii@gmail.com on Wed, 24 September 2014
8 580 Thu, 25 September 2014 04:39
By: lovelysethii@gmail.com
  Row generator
Oracle 10.2
By: m.abdulhaq on Wed, 24 September 2014
10 518 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 872 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 613 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 496 Wed, 24 September 2014 10:13
By: chof
  Need Materialised view
By: mvrkr44 on Wed, 24 September 2014
2 338 Wed, 24 September 2014 06:54
By: Lalit Kumar B
  minus operator question
By: ora1980 on Tue, 23 September 2014
8 755 Tue, 23 September 2014 14:54
By: Michel Cadot
  BACKUP PACKAGES
By: hahaie on Tue, 23 September 2014
3 468 Tue, 23 September 2014 14:29
By: BlackSwan
  Alternate of UNION ALL
Oracle 10G , Windows 7
By: adilsami on Tue, 23 September 2014
18 582 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 500 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 563 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 434 Tue, 23 September 2014 06:44
By: Lalit Kumar B
  Data in AM/PM
By: kr1347 on Mon, 22 September 2014
4 357 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 914 Mon, 22 September 2014 13:26
By: EdStevens
  Please solve my issue
By: aaditya321 on Sat, 20 September 2014
19 2673 Mon, 22 September 2014 13:06
By: Solomon Yakobson
  mutating trigger
oracle 11g r2
By: guddu_12 on Mon, 22 September 2014
6 633 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 416 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 368 Sat, 20 September 2014 09:35
By: BlackSwan
  Table LOCK in PeopleSoft Program
Oracle SQL
By: gaganmadhu on Fri, 19 September 2014
3 2365 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 2271 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 327 Fri, 19 September 2014 05:26
By: Lalit Kumar B
  SQL Joins
Oracle 11g
By: srinivas.k2005 on Thu, 18 September 2014
17 739 Fri, 19 September 2014 00:06
By: srinivas.k2005
  Question on Trace file
11g
By: andrewscharles89 on Thu, 18 September 2014
4 339 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 671 Thu, 18 September 2014 13:59
By: anil_mk
  Most not NULL record
By: kr1347 on Wed, 17 September 2014
12 489 Thu, 18 September 2014 13:43
By: Michel Cadot
  Selecting a column not in group by clause
Oracle 10g
By: Member2014 on Thu, 24 July 2014
2 539 Thu, 18 September 2014 12:23
By: Member2014
  retrieve multiple records from different table
Oracle 10g
By: ramc07 on Thu, 18 September 2014
4 342 Thu, 18 September 2014 08:27
By: CraigB
  find the sql query based on the timestamp.
11g
By: haadiya on Thu, 18 September 2014
2 367 Thu, 18 September 2014 08:06
By: Michel Cadot
  Help needed with joining two tables
ms sql 2008
By: dusoo on Wed, 17 September 2014
5 350 Thu, 18 September 2014 00:49
By: dusoo
  Can an {interval quantifier} contain a REGEXP_INSTR expression
Oracle Data Provider for .NET 10.2.0.5.0 Production
By: dmparish on Wed, 17 September 2014
2 294 Thu, 18 September 2014 00:46
By: Michel Cadot
  Update command
By: Mayur Shinde on Wed, 17 September 2014
3 348 Wed, 17 September 2014 16:07
By: Bill B
  Performance Issue [Merged]
Oracle 11g Database, Win Xp
By: stalin4d on Wed, 10 September 2014
32 894 Wed, 17 September 2014 14:29
By: Bill B
  How to find total count based on date
Oracle 11gR2
By: pdebasis2013@gmail.com on Wed, 17 September 2014
15 509 Wed, 17 September 2014 12:12
By: Michel Cadot
  TO_NUMBER conversion on NVARCHAR2 column throws ORA-01722: invalid number
12c, 12.1.0.1, Windows 7
By: Lalit Kumar B on Mon, 15 September 2014
4 615 Wed, 17 September 2014 10:51
By: Lalit Kumar B
icon5.gif find value in table (don't know column name yet)
Oracle 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: ecivgamer on Wed, 17 September 2014
9 497 Wed, 17 September 2014 08:52
By: Lalit Kumar B
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: Sat Apr 18 14:26:49 CDT 2015

Total time taken to generate the page: 0.11739 seconds