select to_char(to_number(substr(fee,1,instr('-'))),'99,999,999.99')||'-'||
to_char(to_number(substr(fee,instr('-')+1)),'99,999,999.99')
from course
to_char(to_number(substr(fee,instr('-')+1)),'99,999,999.99')
from course
调试欢乐多
100000
AAAAAA
这种格式的数据!