oracle_sql语法查询.docVIP

一、数学函数 SELECT ROUND(123.35) FROM DUAL;//123 SELECT TRUNC(123.45) FROM DUAL;//123 SELECT ROUND(123.45,-1) FROM DUAL;//120 SELECT TRUNC(123.45,-1) FROM DUAL;//120 二、字符串函数 SELECT LENGTH(HELLO) FROM DUAL;//5 SELECT LPAD(ABC,5,*) FROM DUAL;//**ABC SELECT REPLACE(ABCDEFG,DE,WW) S1,REPLACE(ABCDEFG,DE) S2 FROM DUAL; SELECT SUBSTR(ABCDEFG,1,3) S1,SUBSTR(ABCDEFG,5,5) S2 FROM DUAL; 三、日期函数 SELECT TO_CHAR(SYSDATE,DD-MON-YY HH:MI:SS),ADD_MONTHS(SYSDATE,3) FROM DUAL; SELECT SYSDATE,LAST_DAY(SYSDATE),LAST_DAY(SYSDATE) + 1 FROM DUAL; SELECT MONTHS_BETWEEN(SYSDATE,25-12月-06) FROM DUAL; SELECT NEXT_DAY(SYSDATE,星