原帖由 newdelete 于 2009-2-13 13:35 发表
SQL> select * from v$version;
BANNER
---------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pro
PL/SQL Release 10.2.0.1.0 - Production
CORE10.2.0.1.0Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> select log(2,8) from dual;
LOG(2,8)
----------
3
SQL> select trunc(log(2,8)) from dual;
TRUNC(LOG(2,8))
---------------
2
SQL> select trunc(3) from dual;
TRUNC(3)
----------
3
SQL>
TYCC@ccdb>select log(2,8) from dual;
LOG(2,8)
----------
3
Elapsed: 00:00:00.01
TYCC@ccdb>select trunc(log(2,8)) from dual;
TRUNC(LOG(2,8))
---------------
2
Elapsed: 00:00:00.00
TYCC@ccdb>select trunc(3) from dual;
TRUNC(3)
----------
3
Elapsed: 00:00:00.01
TYCC@ccdb>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE10.2.0.4.0Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production
Elapsed: 00:00:00.04
TYCC@ccdb>
|