update test_table set test=substr(test,1,instr(test,'.')-1) where test like '%.%'
update test_table set test=round(test,0)
update test_table set test=round(test,0) where test <> trunc(test);
或者这样也行 select trunc(cast(test as number),-1) from test_table
update test_table set test=0
1.update test_table set test=round(test,0) where test <> trunc(test); 2.select trunc(cast(test as number),-1)from test_table 3.update test_table set test=substr(test,1,instr(test,'.')-1) where test like '%.%' 4.update test_table set test=to_char(test) where test like '%.%';
select trunc(cast(test as number),-1)
from test_table
2.select trunc(cast(test as number),-1)from test_table
3.update test_table set test=substr(test,1,instr(test,'.')-1) where test like '%.%'
4.update test_table set test=to_char(test) where test like '%.%';