decode

If-x-Then-return value - Else-y

   decode(expression, search1, return1, [search2, return2]...[default])

You can convert a character or expression that contains a number into an actual number value.

The 'format' must be a valid Number format.

nls_lang allows international formats to be applied e.g. currency symbols and numeric chars.


Back to the Top

Simon Sheppard
SS64.com