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

Wednesday May 2nd 2007 by DatabaseJournal.com Staff
Share:

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

[From Builder.com]

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://builder.com.com/5100-6388_14-6180606.html?tag=sc

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved