Oracle SQL string functions
来源:互联网 发布:java 字符串查找 编辑:程序博客网 时间:2024/06/11 02:01
(1),nlv(expr1,exp2)
当expr1不null时,返回expr1
当expr1为null时,返回expr2
(2),lnnvl(condition)
排除指定条件函数
(3),MOD(n1,n2)
n1为被除数,n2为除数;
当n2为0时,返回n1,即除数为0时,返回被除数的值.
(4),去除字符函数
trim('字符串') 去除字符串头尾的空格;
trim('字符' from '字符串') 默认去除头尾字符;
trim(leading|trailing|both '字符' from '字符串') 指定去除的头,尾,头尾部的字符串
(5),判断正负值函数
sign(正数) 返回1;
sign(负数) 返回-1;
sign(0) 返回0
(6),decode(表达式,值1,结果1,值2,结果2...)
表达式的值为值1时,返回结果1;
表达式的值为值2时,返回结果2
- Oracle SQL string functions
- Advanced SQL functions in Oracle 10g
- SQL Query to get Oracle Menus & Functions
- SQL Query to get Oracle Menus & Functions .
- Oracle Functions
- SQL Functions
- SQL functions
- Advanced SQL Functions in Oracle 10g, Richard Earp
- Perl String Functions
- C++ string functions
- tchar string functions
- Simple String Compression Functions
- Basic String Handling Functions
- XPath(6) string functions
- wxWidgets String functions
- PHP FUNCTIONS: n12br('string')
- SAS String Functions
- String hash functions
- 《C++Primer Plus》学习笔记(七)
- ORA-00997: illegal use of LONG datatype
- Oracle SQL Having Where Group by
- 浮点数的二进制表示学习笔记
- Algorithms Review: Divide and Conquer(Binary Search & Merge Sort)
- Oracle SQL string functions
- 关于C# this 指针
- Oracle returns NULL after join
- Spring学习笔记(AOP面向切面编程)
- Oracle IN & EXISTS
- Oracle cursor
- ThinkPHP的调用css,js和图片的路径
- Oracle Block Extent Segment Tablespace
- ORA-19588: archived log recid 181834 stamp 780173554 is no longer valid