当前位置:文档之家› ORACLE常用数值函数、转换函数、字符串函数介绍.docx

ORACLE常用数值函数、转换函数、字符串函数介绍.docx

ORACLE常用数值函数、转换函数、字符串函数介绍.docx

ORACLE USES numeric functions, transformation functions, and string functions?

Numerical function:

The absolute value of abs (m) m

Mod m (n) m is the remainder of n

Power (m, n) m to the n

Round (m [n]) m four round the decimal point (n default is 0).

Trunc (m [n]) m intercepts the value of n bits (n defaults to 0)

Character function:

Initcap (st) returns st to capitalize the first letter of each

word, all other letter lowercase

Lower (st) returns st to all lowercase letters of each word

Upper (st) returns st to capitalize the letters of each word

相关主题
文本预览
相关文档 最新文档