©Mike Moxcey 1999

SQL*Plus DECODE

General syntax:
select DECODE(field,
'table_value_1', 'display_value_1',
'table_value_2', 'display_value_2',
'table_value_3', 'display_value_3', ...
'display_value_default') field_alias (optional; can be same)


home next