SELECT TRUNCATE(ROUND(123.456,2),0)
FROM DUAL;
运行结果如下所示:
角度与弧度互换函数
具体代码如下所示:
#角度与弧度的互换
SELECT RADIANS...(30),RADIANS(45),RADIANS(60),RADIANS(90),
DEGREES(2*PI()),DEGREES(RADIANS(60))
FROM DUAL;
运行结果如下所示:...三角函数
#三角函数
SELECT SIN(RADIANS(30)),DEGREES(ASIN(1)),TAN(RADIANS(45)),DEGREES(ATAN(1))
FROM DUAL;
运行结果如下所示