内置pl/sql函数

Table 2-4 Built-In Functions

Error	Number	Character	Conversion	Date	Obj Ref	Misc
SQLCODE SQLERRM	ABS ACOS ASIN ATAN ATAN2 BITAND CEIL COS COSH EXP FLOOR LN LOG MOD POWER REMAINDER ROUND SIGN SIN SINH SQRT TAN TANH TRUNC	ASCII ASCIISTR CHR COMPOSE CONCAT DECOMPOSE INITCAP INSTR INSTR2 INSTR4 INSTRB INSTRC LENGTH LENGTH2 LENGTH4 LENGTHB LENGTHC LOWER LPAD LTRIM NCHR NLS_INITCAP NLS_LOWER NLSSORT NLS_UPPER REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR SUBSTR2 SUBSTR4 SUBSTRB SUBSTRC TRANSLATE TRIM UNISTR UPPER	CHARTOROWID CONVERT HEXTORAW RAWTOHEX RAWTONHEX ROWIDTOCHAR TO_BINARY_DOUBLE TO_BLOB TO_BINARY_FLOAT TO_CHAR TO_CLOB TO_DATE TO_MULTI_BYTE TO_NCHAR TO_NCLOB TO_NUMBER TO_SINGLE_BYTE	ADD_MONTHS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DBTIMEZONE EXTRACT FROM_TZ LAST_DAY LOCALTIMESTAMP MONTHS_BETWEEN NEW_TIME NEXT_DAY NUMTODSINTERVAL NUMTOYMINTERVAL ROUND SCN_TO_TIMESTAMP SESSIONTIMEZONE SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TIMESTAMP_TO_SCN TO_DSINTERVAL TO_TIME TO_TIME_TZ TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL TRUNC TZ_OFFSET	DEREF REF TREAT VALUE	BFILENAME COALESCE DECODE DUMP EMPTY_BLOB EMPTY_CLOB GREATEST LEAST NANVL NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NULLIF NVL SYS_CONTEXT SYS_GUID UID USER USERENV VSIZE