Tag:LOWER

  • Oracle functions

    Time:2020-11-18

    1. ASCII returns the decimal number corresponding to the specified character; 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 gives an integer and returns the corresponding character; SQL> select chr(54740) zhao,chr(65) chr65 from dual; ZH C — –Zhao a […]