selectdecode(substr(num,1,1),'.',255)!important">'0'||num,num)fromtable_name
select
decode(substr(num,1,1),
'.'
,255)!important">'0'
||num,num)
from
table_name
这个方案很好
