Oracle函数语法速查

001 ABS 002 ACOS 003 ADD_MONTHS
004 ASCII 005 ASCIISTR 006 ASIN
007 ATAN 008 ATAN2 009 AVG
010 BFILENAME 011 BIN_TO_NUM 012 BITAND
013 CAST 014 CEIL 015 CHARTOROWID
016 CHR 017 COALESCE 018 COMPOSE
019 CONCAT 020 CONVERT 021 CORR
022 COS 023 COSH 024 COUNT
025 COVAR_POP 026 COVAR_SAMP 027 CURRENT_DATE
028 CURRENT_TIMESTAMP 029 DBTIMEZONE 030 DECODE
031 DECOMPOSE 032 DEREF 033 DUMP
034 EMPTY_BLOB, EMPTY_CLOB 035 EXISTSNODE 036 EXP
037 FLOOR 038 FROM_TZ 039 GREATEST
040 GROUP_ID 041 GROUPING 042 GROUPING_ID
043 HEXTORAW 044 INITCAP 045 INSTR
046 INSTRB 047 INSTRC 048 INSTR2
049 INSTR4 050 LAST_DAY 051 LEAST
052 LENGTH 053 LENGTHB 054 LENGTHC
055 LENGTH2 056 LENGTH4 057 LN
058 LOCALTIMESTAMP 059 LOG 060 LOWER
061 LPAD 062 LTRIM 063 MAKE_REF
064 MAX 065 MIN 066 MOD
067 MONTHS_BETWEEN 068 NCHAR 069 NEW_TIME
070 NEXT_DAY 071 NLS_CHARSET_DECL_LEN 072 NLS_CHARSET_ID
073 NLS_CHARSET_NAME 074 NLS_INITCAP 075 NLS_LOWER
076 NLS_UPPER 077 NLSSORT 078 NULLIF
079 NUMTODSINTERVAL 080 NUMTOYMINTERVAL 081 NVL
082 NVL2 083 POWER 084 RATIO_TO_REPORT
085 RAWTOHEX 086 RAWTONHEX 087 REFTOHEX
088 REPLACE 089 ROUND 090 ROWIDTOCHAR
091 ROWIDTONCHAR 092 RPAD 093 RTRIM
094 SESSIONTIMEZONE 095 SIGN 096 SIN
097 SINH 098 SOUNDEX 099 SQRT
100 STDDEV 101 STDDEV_POP 102 STDDEV_SAMP
103 SUBSTR 104 SUBSTRB 105 SUBSTRC
106 SUBSTR2 107 SUBSTR4 108 SUM
109 SYS_CONNECT_BY_PATH 110 SYS_CONNECT 111 SYS_DBURIGEN
112 SYS_EXTRACT_UTC 113 SYS_GUID 114 SYS_TYPEID
115 SYS_XMLAGG 116 SYS_XMLGEN 117 SYSDATE
118 SYSTIMESTAMP 119 TAN 120 TANH
121 TO_CHAR 122 TO_CLOB 123 TO_DATE
124 TO_DSINTERVAL 125 TO_LOB 126 TO_MULTI_BYTE
127 TO_NCHAR 128 TO_NLOB 129 TO_NUMBER
130 TO_SINGLE_BYTE 131 TO_TIMESTAMP 132 TO_TIMESTAMP_TZ
133 TO_YMINTERVAL 134 TRANSLATE 135 TRANSLATE USING
136 TRUNC 137 UID 138 UINSTR
139 UPPER 140 USER 141 USERENV
142 VALUE 143 VAR_POP 144 VAR_SAMP
145 VARIANCE 146 VSIZE  

海内存知已,天涯若比邻,欢迎您加入劝学网以下QQ群,结识志同道合的朋友:
劝学网儒家群(136761088) 劝学网道家群(121709505) 劝学网佛家群(130338651)
劝学网周易群(123208056) 劝学网历史群(154204903) 劝学网国学讲堂群(103317201)
纠错或者投稿联系方式:电话 :020-85626400 联系E-mail:513205549@qq.com QQ联系:513205549