取一个一维数组中的最大值greatest
SELECT Greatest('11','10','9','20') FROM dual;
--显示为9
SELECT Greatest(11,10,9,20) FROM dual;
--显示为20
SELECT Greatest('A','a','ab','AB') FROM dual;
--显示为ab
取一个一维数组中的最小值least
SELECT Least('11','10','9','20') FROM dual;
--显示为10
SELECT Least(11,10,9,20) FROM dual;
--显示为9
SELECT Least('A','a','ab','AB') FROM dual;
--显示为A
全角的数字/字母/标点符号转半角to_single_byte
SELECT To_Single_Byte('21,500(消费水平)US$@¥55/pc') FROM dual;
--显示:21,500(消费水平)US$@¥55/pc