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.

This story continues at
http://www.dbasupport.com/oracle/new...d_errors.shtml