示例:
SELECT ASCII('a') FROM dual;
SELECT CONCAT('Hello','world') FROM dual;
SELECT INSTR('Hello world','or') FROM dual;
SELECT LENGTH('Hello') FROM dual;
SELECT LOWER('Hello') FROM dual;
SELECT UPPER('hello') FROM dual;
SELECT LTRIM('=Hello=','=') FROM dual;
SELECT RTRIM('=Hello=','=') FROM dual;
SELECT TRIM('='FROM'=Hello=') FROM dual;
SELECT REPLACE('ABCDE','CD','AAA')FROM dual;
SELECT SUBSTR('ABCDE',2,3) FROM dual;
示例:
SELECT SYSDATE FROM DUAL;
SELECT ADD_MONTHS(SYSDATE,5) FROM DUAL;
SELECT LAST_DAY(SYSDATE) FROM DUAL;
SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL;