--取最大值,最小值
SELECT Greatest('a','x','fit','xa') FROM dual;
SELECT Least('a','x','fit','xa','ab') FROM dual;
select Greatest(1,34,25,689,0.1) from dual
select Least(1,34,25,689,0.1) from dual
--全角转半角
SELECT Greatest('a','x','fit','xa') FROM dual;
SELECT Least('a','x','fit','xa','ab') FROM dual;
select Greatest(1,34,25,689,0.1) from dual
select Least(1,34,25,689,0.1) from dual
--全角转半角
SELECT To_Single_Byte('21,500円(消費税別)US$@¥55/pc.,,') FROM dual;
ceil和floor函数在一些业务数据的时候,有时还是很有用的。
ceil(n) 取大于等于数值n的最小整数;
floor(n)取小于等于数值n的最大整数