does oracle 7 support CASE statement

does oracle 7 support this statement SQL ?  

SELECT T1.name,

          CASE when T1.sex = 'M' then 'Male'
               when T1.sex = 'F' then 'Female'
               ELSE  'Unknown'
          end as "gender"
 FROM     pers T1

i don't know if CASE statement is supported by ANSI-92, while Oracle 7 support - i think - ANSI-92

thanx
m. Received on Tue May 14 2002 - 06:37:56 CDT