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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 40272 Mon, 05 September 2011 02:20
By: Littlefoot
  find the sql query based on the timestamp.
11g
By: haadiya on Thu, 18 September 2014
0 1 Thu, 18 September 2014 06:42
By: haadiya
  retrieve multiple records from different table
Oracle 10g
By: ramc07 on Thu, 18 September 2014
2 77 Thu, 18 September 2014 04:07
By: John Watson
  Help needed with joining two tables
ms sql 2008
By: dusoo on Wed, 17 September 2014
5 153 Thu, 18 September 2014 00:49
By: dusoo
  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
11 250 Thu, 18 September 2014 00:49
By: Lalit Kumar B
  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 104 Thu, 18 September 2014 00:46
By: Michel Cadot
  Update command
By: mayur.shinde511@gmail.com on Wed, 17 September 2014
3 160 Wed, 17 September 2014 16:07
By: Bill B
  Most not NULL record
By: kr1347 on Wed, 17 September 2014
10 204 Wed, 17 September 2014 14:49
By: Littlefoot
  Performance Issue [Merged]
Oracle 11g Database, Win Xp
By: stalin4d on Wed, 10 September 2014
32 627 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 244 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 253 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 216 Wed, 17 September 2014 08:52
By: Lalit Kumar B
  Index not used when querying views
oracle 11g
By: elaiyavel on Wed, 17 September 2014
2 95 Wed, 17 September 2014 08:43
By: Lalit Kumar B
  need database trigger
By: mist598 on Wed, 17 September 2014
24 373 Wed, 17 September 2014 08:09
By: Michel Cadot
  implementation restriction: cannot reference fields of bulk in-bind table of records error
By: aditi5 on Wed, 17 September 2014
2 92 Wed, 17 September 2014 06:47
By: Lalit Kumar B
  duplicate record
oracle 10 g
By: simplesanju on Wed, 17 September 2014
2 125 Wed, 17 September 2014 02:42
By: Michel Cadot
  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 576 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 129 Tue, 16 September 2014 16:43
By: sspn2010
  Cursor Problem
Oracle
By: nmuthu_samy on Sun, 14 September 2014
6 313 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 303 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 348 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 698 Tue, 16 September 2014 01:34
By: m.abdulhaq
  Compare two rows from a same table
By: deepugun on Mon, 15 September 2014
2 202 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 143 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 1343 Mon, 15 September 2014 13:49
By: Michel Cadot
  Query tuning.
By: harshad288 on Thu, 11 September 2014
11 411 Mon, 15 September 2014 00:07
By: harshad288
  Duplicate rows
Oracle 10g
By: bobghw on Sun, 14 September 2014
4 235 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 249 Sun, 14 September 2014 00:50
By: Littlefoot
  Frequency of sub-programs used in database
By: vippysharma on Fri, 12 September 2014
6 264 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 247 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 288 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 1717 Fri, 12 September 2014 07:37
By: EdStevens
  join query
By: mayur.shinde511@gmail.com on Fri, 12 September 2014
8 242 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 564 Thu, 11 September 2014 17:45
By: djbjr70
  RAISE_APPLICATION_ERROR
Oracle 10.2.0.5
By: praveenramaswamy on Thu, 11 September 2014
3 138 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 301 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 265 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 269 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 250 Wed, 10 September 2014 10:23
By: manubatham20
  Will Procedure compile
By: aaditya321 on Wed, 10 September 2014
2 167 Wed, 10 September 2014 07:36
By: EdStevens
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 06:44:42 CDT 2014

Total time taken to generate the page: 0.11719 seconds