1
2
3
4
5
6
7
8
select substr(a,0,length(a)-6 )
from ( select '123456789123456789' a from dual) ;
 
select trunc(a/1000000)
from ( select 123456789123456789 a from dual);
 
select a/1000000
from ( select 123456789123456789 a from dual);
이렇게 하면 되는데 더 좋은거 아시면 알려주세요.

+ Recent posts