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); |
sql 원 단위를 백만원 단위로 보여주기
2009. 1. 8. 17:23