|
|
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.