©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