Decode Function
Function | Description | Examples |
|---|---|---|
DECODE | Checks for a value and if there is a match, replaces it with another constant or database field value. | Use this function to display Success if the status is 0, Warning if the status is 1, and Failed if the status is 0. DECODE(summary_status, 0, 'Success', 1, 'Warning', 2, 'Failed') |