plsql有select case这样的语句吗？

orcl

There is a case statement introduced in 8.1.6. However it will function like decode. Rumor said that Oracle will get ride of decode in the future.
The following code has been tested sucessfully in Oracle 8.1.6/NT.
select 'CREATE '||
case when contents='TEMPORARY' THEN 'TEMPORARY'
when contents='PERMANENT' then null
else null
end
||'TABLESAPCE '||tablespace_name
from dba_tablespaces;

graydolphin

"CASE expressions let you use IF ... THEN ... ELSE logic in SQL statements without
having to invoke procedures." --------<<SQL Reference>>
This statement imply that Case When can only be used in SQL statement.
I've been looking for such Case When in Pl/SQL, but haven't found yet. Thus I use if....elsif.......... as substitution.

woodpile

俺有一个怪办法，不知道会不会有问题
自定义异常，在异常里处理，
这样if then 就比较清楚了