'PL/SQL' Category

• Exceptions in ORACLE PL/SQL

  June 14, 2009

  Error or Warning of any kind is called as Exception in Oracle which can be predefined or user-defined. Predefined exceptions are raised implicitly by the system. User-defined exceptions must be raised explicitly by RAISE statements. To handle raised exceptions, we write separate routines called exception handlers There are four kinds of exceptions in PL/SQL they [...]

  What do you think of this post?

  Awesome (2) Interesting (0) Useful (0) Boring (0) Sucks (0)

  posted in Oracle, PL/SQL by chandu

• SELECT FOR UPDATE in PL/SQL Cursors

  April 30, 2009

  When we  issue a SELECT statement against the database to query some records, no locks are placed on the selected rows. Only those records which have been changed but not yet committed are locked Others will be able to read those records as they appeared before the change. When you  want to lock a set [...]

  What do you think of this post?

  Awesome (0) Interesting (1) Useful (0) Boring (0) Sucks (0)

  posted in Oracle, PL/SQL by chandu