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
  Is there a way to select columns with largest column for each specific row
11.2.0.3
By: kytemanaic on Mon, 15 September 2014
15 777 Wed, 17 September 2014 00:15
By: Michel Cadot
  Query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Tue, 16 September 2014
3 282 Tue, 16 September 2014 16:43
By: sspn2010
  Cursor Problem
Oracle
By: nmuthu_samy on Sun, 14 September 2014
6 497 Tue, 16 September 2014 15:04
By: Bill B
  ORA-14141: ALTER INDEX VISIBLE|INVISIBLE may not be combined with other operations
By: mist598 on Tue, 16 September 2014
11 711 Tue, 16 September 2014 11:23
By: Michel Cadot
  Oracle doesn't use a partial index
Oracle 11g
By: iblazquez on Mon, 15 September 2014
6 468 Tue, 16 September 2014 09:08
By: iblazquez
  regexp_replace. Add double quote(") to string of values
10.2
By: lott42 on Wed, 20 August 2014
11 974 Tue, 16 September 2014 01:34
By: m.abdulhaq
  Compare two rows from a same table
By: deepugun on Mon, 15 September 2014
2 353 Tue, 16 September 2014 01:21
By: Michel Cadot
icon9.gif Several rows data in a column adding in one row group by catagory
ORACLE 11g
By: ocpsujon on Mon, 15 September 2014
2 271 Mon, 15 September 2014 22:04
By: ocpsujon
  Need procedure to execute CLOB as paramter
oracle 11g
By: mvrkr44 on Sun, 14 September 2014
38 1532 Mon, 15 September 2014 13:49
By: Michel Cadot
  Query tuning.
By: harshad288 on Thu, 11 September 2014
11 595 Mon, 15 September 2014 00:07
By: harshad288
  Duplicate rows
Oracle 10g
By: bobghw on Sun, 14 September 2014
4 394 Sun, 14 September 2014 16:28
By: bobghw
  how to use PL/SQL in a before insert trigger to check a value.
By: mattfriend on Sat, 13 September 2014
4 403 Sun, 14 September 2014 00:50
By: Littlefoot
  Frequency of sub-programs used in database
By: vippysharma on Fri, 12 September 2014
6 397 Sat, 13 September 2014 01:59
By: vippysharma
  Fetch IP Addresses between given IP Range
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: manubatham20 on Fri, 12 September 2014
9 493 Fri, 12 September 2014 23:59
By: Solomon Yakobson
  Count employees for a department
Oracle 10g
By: ind!@2020 on Fri, 12 September 2014
11 459 Fri, 12 September 2014 10:47
By: Michel Cadot
  interact command line select to files in this ?
Sql Plus Oracle12c Release 1
By: navaminroad on Mon, 18 August 2014
37 1992 Fri, 12 September 2014 07:37
By: EdStevens
  join query
By: Mayur Shinde on Fri, 12 September 2014
8 358 Fri, 12 September 2014 02:44
By: Lalit Kumar B
  ".." Character coming instead of "." while creating an excel spreadsheet from Oracle 10g
Oracle 10g
By: peterf on Mon, 30 September 2013
4 715 Thu, 11 September 2014 17:45
By: djbjr70
  RAISE_APPLICATION_ERROR
Oracle 10.2.0.5
By: praveenramaswamy on Thu, 11 September 2014
3 260 Thu, 11 September 2014 14:23
By: Michel Cadot
  WHERE name != 'HENRY' excludes name which has NULL
By: rkhatiwala on Tue, 09 September 2014
9 439 Thu, 11 September 2014 10:23
By: Lalit Kumar B
  Help required for SQL query to fetch desired records
oracle 11g/windows
By: gupta27 on Wed, 10 September 2014
8 397 Thu, 11 September 2014 08:58
By: joy_division
  Masking of Customer Data
Oracle 10gr2 Windows OS
By: tigsav on Wed, 10 September 2014
10 389 Thu, 11 September 2014 02:03
By: Maaher
  Removing Junk Characters
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: manubatham20 on Wed, 10 September 2014
9 475 Wed, 10 September 2014 10:23
By: manubatham20
  Will Procedure compile
By: aaditya321 on Wed, 10 September 2014
2 272 Wed, 10 September 2014 07:36
By: EdStevens
  Replace strings before certain characters
Oracle 10g
By: m.abdulhaq on Wed, 27 August 2014
12 848 Wed, 10 September 2014 06:24
By: m.abdulhaq
  query to find two highest salaries in each department
By: sujana123 on Wed, 10 September 2014
2 273 Wed, 10 September 2014 05:29
By: Michel Cadot
  Help SUM
Oracle, 8.1.7.0.0,Windows 2003
By: kumarvk on Wed, 10 September 2014
3 277 Wed, 10 September 2014 05:27
By: Michel Cadot
  Parallel hint issue
oracle 11g / unix
By: balaji123 on Tue, 09 September 2014
2 257 Wed, 10 September 2014 00:11
By: Michel Cadot
  RPAD problem
By: henckel on Thu, 02 March 2006
5 1328 Tue, 09 September 2014 15:10
By: BlackSwan
  How to fetch last five year data
Oracle 11g
By: na.dharma@gmail.com on Tue, 09 September 2014
3 457 Tue, 09 September 2014 09:21
By: Lalit Kumar B
  Time based alerting
Oracle 10g
By: ind!@2020 on Tue, 09 September 2014
6 400 Tue, 09 September 2014 05:05
By: ind!@2020
  condition basis where clause
oracle 10 G
By: simplesanju on Tue, 09 September 2014
2 299 Tue, 09 September 2014 03:29
By: simplesanju
  ORDER BY gives good performance or INDEX hint gives good performance.
Oracle 11g
By: ramya_162 on Mon, 08 September 2014
3 590 Mon, 08 September 2014 07:31
By: EdStevens
  To log the row in error while selecting from database
Oracle 10g
By: gopal.biswal on Sun, 07 September 2014
8 411 Mon, 08 September 2014 03:14
By: cookiemonster
  Getting only the first occurrence of the sub string in the given string
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionE
By: saipradyumn on Fri, 05 September 2014
12 685 Mon, 08 September 2014 00:29
By: saipradyumn
  Show only one of the duplicate values ​​in a column
By: hahaie on Sun, 07 September 2014
5 297 Sun, 07 September 2014 23:09
By: BlackSwan
  Exception : No data
Oracle 11g
By: Oracle_Walker on Thu, 04 September 2014
13 566 Sun, 07 September 2014 04:19
By: Littlefoot
  Compare values between two different tables
11g
By: haadiya on Sat, 06 September 2014
7 458 Sat, 06 September 2014 09:04
By: Lalit Kumar B
icon8.gif ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 , Linux s600986dc3sl04.clouddb.savvis.net 2.6.18-194.17.1.el5 #
By: manishdba007 on Sat, 06 September 2014
4 549 Sat, 06 September 2014 03:26
By: manishdba007
  Problem in Insersion
SQL, 11g Release 11.2.0.2.0 ,Win7
By: shumail on Fri, 05 September 2014
2 468 Fri, 05 September 2014 14:00
By: shumail
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 Mar 05 15:12:20 CST 2015

Total time taken to generate the page: 0.20766 seconds