说明：  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)