110个oracle常用函数总结
<br />1. ASCII<br />返回与指定的字符对应的十进制数;<br />SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;<br />A A ZERO SPACE<br />--------- --------- --------- ---------<br />65 97 48 32<br /><br />2. CHR<br />给出整数,返回对应的字符;<br />
复制链接