Three ways to avoid Case Not Found errors in PL/SQL

Monday Dec 24th 2007 by DatabaseJournal.com Staff

Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. We present three ways to code around this error.

[From Builder AU]

PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE function does), and it also lets you execute one or more statements for the first matching value. The searched CASE statement lets you test multiple expressions and execute one or more statements based on the first expression that is found to be true.

The article continues at http://www.builderau.com.au/program/oracle/soa/Three-ways-to-avoid-Case-Not-Found-errors-in-PL-SQL/0,339028441,339284685,00.htm

Mobile Site | Full Site