Originally posted by OCPIP
as Chris said,
No - you cannot do directly what you are asking.

Case can be used only in 9i onwards and in PL/SQL only. Question is for Decode.


Truncate can do the job but what if I want to know if the age is equal to 15.

case can be used since 8i, in SQL actually, in PL/SQL you have to put them in dynamic SQL

in 9i when you case in PL/SQL then it´s more like case in other languages, you can use case as well in SQL