专注于互联网--专注于架构

oracle函数大全:Oracle SQL内置函数大全(一)

="t18"> 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 [阅读全文] [PDF]