'Oracle' Tag
-
Exceptions in ORACLE PL/SQL
June 14, 2009Error 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 [...]
-
Oracle CASE expression – Implementing IF-THEN-ELSE logic in SQL
May 12, 2009Oracle CASE expression let us implement IF-THEN-ELSE logic in SQL statements with out invoking PL/SQL functions. There are two kinds of CASE expressions 1) Simple CASE expression 2) Searched CASE expression 1) Simple CASE statement Syntax Example In a simple CASE expression, Oracle searches for the first WHEN … THEN pair for which expr is [...]