select to_number('$8,000.80','$999,999,999.99') from dual;
8,000.80' 要轉(zhuǎn)換的值
'$999,999,999.99' 格式字符串