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

《Oracle函数语法速查》简介

本文为欧阳卫兵老师在日本工作时，为公司编写的内部培训资料。

购买本书请到“劝学网书城”