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
  Execute a sql script depending on number of records in a table
11.2.0.4 on Linux
By: orausern on Mon, 29 June 2015
8 294 Mon, 29 June 2015 11:12
By: orausern
  Oracle Table last access detail
Oracle 11g
By: ashish.tiwari on Fri, 26 June 2015
5 390 Sun, 28 June 2015 00:27
By: Lalit Kumar B
  default value on update in oracle 11G
Oracle 11G , Windows 7
By: live4learn on Thu, 25 June 2015
2 1231 Fri, 26 June 2015 10:22
By: Bill B
  Date format help
oracle 11g
By: gorants on Thu, 25 June 2015
3 289 Fri, 26 June 2015 06:56
By: EdStevens
  Update Join..
Oracle 11.2.0.4/Windows 64 bit
By: sant_new1 on Thu, 25 June 2015
4 279 Thu, 25 June 2015 10:23
By: sant_new1
  pl/sql statement ignored
By: raja_rani on Wed, 24 June 2015
9 401 Thu, 25 June 2015 03:20
By: cookiemonster
  Compressing the partitions
11.2..0.4
By: varunvir on Thu, 18 June 2015
8 646 Wed, 24 June 2015 06:44
By: Roachcoach
  Update a column in table only if a condition is met for number of values for a field in other table
By: suhaas on Fri, 19 June 2015
10 715 Tue, 23 June 2015 13:33
By: Bill B
icon5.gif Substitute variable in script
oracle 11g r2
By: ajaapba on Mon, 22 June 2015
7 524 Tue, 23 June 2015 09:20
By: gazzag
  Date Parameter Issue
By: dilip.nnitw@gmail.com on Mon, 22 June 2015
3 517 Tue, 23 June 2015 04:13
By: dilip.nnitw@gmail.com
  Design to Validate Staging records (merged)
ORACLE 11g
By: jagadeesh.nraj on Mon, 15 June 2015
10 748 Mon, 22 June 2015 13:39
By: ravikanth_b
  SQL Query Case and Count
Oracle
By: elements92 on Fri, 19 June 2015
6 483 Mon, 22 June 2015 05:11
By: cookiemonster
  date format from string
Oracle 11g
By: mape on Fri, 19 June 2015
16 552 Mon, 22 June 2015 04:22
By: cookiemonster
  require output in described order
oracle 11g
By: jgjeetu on Sun, 21 June 2015
3 284 Sun, 21 June 2015 08:37
By: jgjeetu
  Managing the backup tables
Oracle, 11g
By: scorpy90 on Sat, 20 June 2015
2 326 Sat, 20 June 2015 14:16
By: John Watson
  Generate Start - End date
11.2
By: lott42 on Fri, 19 June 2015
2 327 Fri, 19 June 2015 13:42
By: lott42
  'Free text' select statment
Oracle 4.0.2.15.21
By: SteveShephard on Fri, 19 June 2015
2 298 Fri, 19 June 2015 06:54
By: Michel Cadot
  Split rows into columns
4.0.2.15.21
By: SteveShephard on Fri, 19 June 2015
3 318 Fri, 19 June 2015 06:52
By: Michel Cadot
  Cross tab SQL query
Oracle 9i
By: tarasasu on Mon, 15 June 2015
13 714 Fri, 19 June 2015 03:23
By: pablolee
  Function declartation
oracle 10g
By: arun888 on Fri, 19 June 2015
3 252 Fri, 19 June 2015 02:40
By: arun888
  dynamic input value passing
ORACLE 10G
By: arun888 on Thu, 18 June 2015
3 267 Thu, 18 June 2015 09:47
By: Michel Cadot
  PL SQL - Need to create archive table - [MERGED]
By: rajivgandhiram on Tue, 16 June 2015
6 563 Wed, 17 June 2015 01:42
By: Lalit Kumar B
  Create VIEW retrieving from dynamically configured table/queries
By: gtriant on Thu, 11 June 2015
20 797 Tue, 16 June 2015 16:03
By: gtriant
  How To Check Images with Zero Bytes in Size on BLOB column datatype
Oracle 11.2.0.3.0
By: wtolentino on Mon, 15 June 2015
9 515 Tue, 16 June 2015 07:20
By: wtolentino
  Sysdate with time interval parameter
Oracle 11i
By: RADHAKAN on Mon, 15 June 2015
16 598 Tue, 16 June 2015 03:22
By: Michel Cadot
  Read a string char by char and compare
Oracle 11g Solaris 11
By: apenkov on Mon, 15 June 2015
11 525 Tue, 16 June 2015 02:06
By: apenkov
  How to alter the varchar column to number datatype
oracle 11i
By: Jothish on Fri, 12 June 2015
25 1760 Mon, 15 June 2015 03:02
By: pablolee
  Interview Question
oracle 11g
By: anniepeteroracle on Mon, 15 June 2015
4 373 Mon, 15 June 2015 02:06
By: Lalit Kumar B
  IBM DB2 to Oracle PLSQL Current Day and day code conversion
By: pumelayurika on Fri, 12 June 2015
11 1437 Mon, 15 June 2015 00:06
By: Michel Cadot
  merge columns from 2 different tables
oracle 10g
By: nciteamo on Fri, 12 June 2015
1 1027 Fri, 12 June 2015 06:09
By: bugfox
  Duplicate Data
Oracle 11g
By: plsql_guy on Sat, 23 May 2015
36 1489 Fri, 12 June 2015 03:11
By: Michel Cadot
  Procedure or Function
Oracle 109, Windows Server / 7
By: roni_a180 on Thu, 11 June 2015
3 374 Thu, 11 June 2015 08:08
By: cookiemonster
  Difference
9i
By: glmjoy on Wed, 10 June 2015
5 429 Wed, 10 June 2015 23:59
By: Michel Cadot
  What we should use for better function or procedure
By: aaditya321 on Mon, 18 August 2014
10 840 Wed, 10 June 2015 00:54
By: Michel Cadot
  SQL query help
By: Developer9 on Mon, 08 June 2015
8 553 Wed, 10 June 2015 00:50
By: Michel Cadot
  cumulative sum
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
By: naga.oracle on Tue, 09 June 2015
9 438 Tue, 09 June 2015 11:53
By: naga.oracle
  Fast query paging for large table
Oracle 12c,Oracle Linux 6.4
By: fabi88 on Tue, 09 June 2015
3 321 Tue, 09 June 2015 03:21
By: Michel Cadot
  Please help with XML parsing
Oracle 11.2.0.4
By: manubatham20 on Mon, 08 June 2015
4 393 Tue, 09 June 2015 00:54
By: _jum
  ORA-30036 while running a Procedure
9i
By: Jaise on Mon, 08 June 2015
7 356 Mon, 08 June 2015 14:55
By: Michel Cadot
  ORA-02437: cannot validate (TAGICRM.PK_RISK_GRID) - primary key violated
11g, 11.2.0.1, window7
By: ashishkumarmahanta80 on Tue, 02 June 2015
12 810 Mon, 08 June 2015 07:36
By: BlackSwan
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: Sun Aug 02 01:58:28 CDT 2015

Total time taken to generate the page: 0.10823 seconds