case statement help

[theresatan]

Hi,

I got ora-00905:missing keyword error when I ran following:

select case activitykey when activitykey<50 then 50 else 100 end from activity;

Thanks!

Theresa

 

[feherke]

Hi

Remove the first "activitykey" word :

select case when activitykey<50 then 50 else 100 end from activity;

Feherke.

http://rootshell.be/~feherke/

 

[theresatan]

It works.

Thanks!

Theresa