Hi.

The answer is no. The case expression you are talking about is used to derive a value of a single column. It's not like the PL/SQL cas statement that can have whole blocks of code in it.

This might help you understand the difference between a case expression and a case statement.

http://www.oracle-base.com/articles/9i/Case9i.php

Cheers

Tim...