By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
TO_NUMBER('100,12','99999D99','NLS_NUMERIC_CHARACTERS='',.''') |
---|
100.12 |
TO_NUMBER('XXX'DEFAULT-1ONCONVERSIONERROR,'99999D99','NLS_NUMERIC_CHARACTERS='',.''') |
---|
-1 |