摘要:
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-','
阅读全文
posted @ 2010-08-20 15:31
枫叶飞舞
阅读(3813)
推荐(1)
编辑