support for syntax (case when p = x then y else z end )

[Donna]

syntax:
update table t_table
set c_column = (case when p = x then y else z end );

I couldn't compile such a statement.
Is this syntax supported ???????????

If not , does anybody know when will it be supported.

for now I am using a workaround: the execute immediate statement but its very dificult for maintenance .

Thanks

 

[Rob van Rijen]

Can you use a decode statement?

update table t_table
set c_column = decode(p,x,y,z);

 

[whip]

Starting with the 9i version of the database, CASE is supported in PL/SQL.

 

[Donna]

thanks - in 10g db the problem is solved.