如何在PL/SQL中查找字符代码?

  create or replace function asciistr2(s IN varchar2)
  RETURN varchar2
  IS
    result varchar2(32767) := '';
  BEGIN
    FOR i IN 1..Length(s)
      LOOP
      dbms_output.put_line(ASCII(substr(s,i,1)));
      result := result || ASCII(substr(s,i,1));
      END LOOP;
      return result;
  END;


  Select asciistr2('HELLO') from dual

结果:72697679

dbms\U输出

 72
 69
 76
 76
 79

你到底期望什么?看看你的问题,我觉得 ASCII() 会给你所需要的,明白吗 this ASCII tutorial

或者您指的是Unicode值?