oracle字符串替换方法！急！

Question

在函数里A是4683,968,969，我想把A替换成4683$968$969,用什么方法？多谢！

Answer 1

select  replace('4683,968,969',",","$")这样写好像不对，我不知道该怎么写，请教大家！

Answer 2

你写错了,你写了双引号了,应该是select  replace('4683,968,969',',','$')

Answer 3

多谢hebo2005() 。varchar2转换成number用什么方法？多谢。

Answer 4

SQL> select replace('4683,968,969',',','$') from dual;REPLACE('4683,968,969',',','$'
------------------------------
4683$968$969SQL> select to_number('520') from dual;TO_NUMBER('520')
----------------
             520

Answer 5

SQL> select translate('4683,968,969',',','$') from dual;TRANSLATE('4683,968,969',',','
------------------------------
4683$968$969

Answer 6

select to_number('4683,968') from dual
就会提示：无效的数字。

Answer 7

那是自然的,数字里又没有,的
要格式化转换才行的
to_number('4683,968','999,999,999')

Answer 8

这个怎么转换啊，还请hebo2005() 指条明路，小弟sql实在是不好。

Answer 9

SQL> select to_number(replace('4683,968,969',',','')) from dual;TO_NUMBER(REPLACE('4683,968,96
------------------------------
                    4683968969
SQL> select to_number('4683,968,969', '9999999999') from dual;TO_NUMBER('4683,968,969','9999
------------------------------
                    4683968969

Answer 10

select replace('4683,968,969',',','$') from dual;