oracle中常用函数说明.
SQL中的单记录函数
1.ASCII
返回与指定的字符对应的十进制数
SQL> select ascii( A ) A,ascii( a ) a,ascii( 0 ) zero,ascii( ) space from dual
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
给出整数,返回对应的字符
SQL> select chr(54740) zhao,chr(65) chr65 from dual
ZH C
-- -
赵 A
3.CONCAT
连接两个字符串
SQL> select concat( 010- , 88888888 )|| 转23 高乾竞电话 from dual
高乾竞电话
----------------
010-88888888转23
oracle explain commonly used functions. SQL Record function of the single-1.ASCII back with a specified number of characters corresponding to the metric system SQL> select ascii (' ' A' ' ) A, ascii (' ' a' ' ) a, ascii ( ' ' 0' ' ) zero, ascii (' ' ' ' ) space from dual AA ZERO SPACE------------------------------------- 65 97 48 32 2.CHR give integer, return the corresponding character SQL> select chr (54740) zhao, chr (65) chr65 from dual ZH C-- Zhao A 3. CONCAT string connecting the two SQL> select concat (' ' 010-' ' ,' ' 88888888' ' )||' ' competing cadres to 23' ' phone from dual cadres competing phone---------------- 010-88888888 to 23 (2009-03-28, CHM, 67KB, 下载3次)