SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

case statement in Oracle 8i

381825Jul 29 2005 — edited Jul 29 2005

can anyone tell me what to do to make the query below run in Oracle 8i.
thanks

select
case connum
when 'C251234' then 'Good'
when 'C318260' then 'Ok'
else connum end
from names

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2005

Added on Jul 29 2005

7 comments

1,985 views