to_number 怎么转换含有百分号的字符

Question

to_number 怎么转换含有百分号的字符to_number('19.2%',?)转换成19.2

Answer 1

SELECT to_number(REPLACE('19.2%','%'))  FROM dual;

Answer 2

SQL> select TO_NUMBER(TRANSLATE('1a9.2%asdasd','.0123456789'||'1a9.2%asdasd','.0123456789')) from dual;TO_NUMBER(TRANSLATE('1A9.2%ASD
------------------------------
                          19.2

Answer 3

select to_number(translate('19.2%','%',' ')) from dual;

Answer 4

SELECT to_number(REPLACE('19.2%','%',''))  FROM dual;