SQL中的單記錄函數(shù)
1.asciI
返回與指定的字符對(duì)應(yīng)的十進(jìn)制數(shù)
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
給出整數(shù),返回對(duì)應(yīng)的字符
SQL> select chr(54740) zhao,chr(65) chr65 from dual
ZH C
-- -
標(biāo)簽:
asciI
SQL
select
asciI
上傳時(shí)間:
2017-04-14
上傳用戶:330402686