oracle 如何向上取正,或向下取正?在线等ing?????
---------------------------------------------------------------
SQL> select ceil(1234.89) from dual;
CEIL(1234.89)
-------------
1235
SQL>
SQL> select trunc(1234.89) from dual;
TRUNC(1234.89)
--------------
1234
SQL>
oracle 如何向上取正,或向下取正?在线等ing?????
---------------------------------------------------------------
SQL> select ceil(1234.89) from dual;
CEIL(1234.89)
-------------
1235
SQL>
SQL> select trunc(1234.89) from dual;
TRUNC(1234.89)
--------------
1234
SQL>