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