If then Else Di bahasa SQL

Seandainya kita punya statement seperti ::

IF owner = 'SYS' THEN
result := 'The owner is SYS';

ELSIF owner = 'SYSTEM' THEN
result := 'The owner is SYSTEM'';

ELSE
result := 'The owner is another value';

END IF;

maka Penulisan di SQL >>

select table_name,
CASE owner
WHEN 'SYS' THEN 'The owner is SYS'
WHEN 'SYSTEM' THEN 'The owner is SYSTEM'
ELSE 'The owner is another value' END
from all_tables;


select table_name,
CASE owner
WHEN 'SYS' THEN 'The owner is SYS'
WHEN 'SYSTEM' THEN 'The owner is SYSTEM' END
from all_tables;