oracle系统内置函数大全
5星 · 超过95%的资源 需积分: 50 175 浏览量
2016-06-22
13:13:53
上传
评论 3
收藏 328KB PDF 举报 
目录
F.1 字符函数——返回字符值
...........................................................................................................
1
ASCII
..........................................................................................................................................
1
CHR
.............................................................................................................................................
1
CONCAT
.....................................................................................................................................
1
INITCAP
.....................................................................................................................................
2
LTRIM
.........................................................................................................................................
2
LOWER
.......................................................................................................................................
2
NLS_INITCAP
...........................................................................................................................
2
NLS_LOWER
.............................................................................................................................
3
NLS_UPPER
...............................................................................................................................
3
REPLACE
...................................................................................................................................
3
RPAD
...........................................................................................................................................
4
LPAD
...........................................................................................................................................
4
RTRIM
........................................................................................................................................
4
SOUNDEX
..................................................................................................................................
5
SUBSTR
......................................................................................................................................
5
SUBSTRB
...................................................................................................................................
5
TRANSLATE
..............................................................................................................................
5
TRIM
...........................................................................................................................................
6
UPPER
........................................................................................................................................
6
F.2 字符函数——返回数字
...............................................................................................................
6
ASCII
..........................................................................................................................................
6
INSTR
.........................................................................................................................................
7
INSTRB
.......................................................................................................................................
7
LENGTH
.....................................................................................................................................
7
LENGTHB
..................................................................................................................................
7
NLSSORT
...................................................................................................................................
8
F.3 数字函数
.......................................................................................................................................
8
ABS
.............................................................................................................................................
8
ACOS
..........................................................................................................................................
8
ASIN
............................................................................................................................................
8
ATAN
..........................................................................................................................................
9
ATAN2
........................................................................................................................................
9
CEIL
............................................................................................................................................
9
COS
.............................................................................................................................................
9
COSH
........................................................................................................................................
10
EXP
...........................................................................................................................................
10
FLOOR
......................................................................................................................................
10
LN
..............................................................................................................................................
10
LOG
...........................................................................................................................................
10
MOD
.........................................................................................................................................
11
POWER
.....................................................................................................................................
11
剩余38页未读，继续阅读
评论1
最新资源