oracle中ascii函数及to_char函数使用及编码间的转换

最新推荐文章于 2021-04-12 11:14:10 发布

cstp22747

最新推荐文章于 2021-04-12 11:14:10 发布

阅读量350

点赞数

文章标签：数据库

一、ascii->char

SQL> CREATE OR REPLACE PROCEDURE pasc_to_char(one IN VARCHAR2)
2 --RETURN VARCHAR2
3 AS
4 i NUMBER:=1;
5 two VARCHAR2(200):='';
6
7 BEGIN
8 FOR i IN 1..length(one)-1
9 LOOP
10 two:=two||TO_CHAR(ASCII(SUBSTR(one,i,1)));
11 DBMS_OUTPUT.put_line(two);
12 END LOOP;
13 --RETURN two;
14 -- DBMS_OUTPUT.put_line(two);
15 END;
16 /

Procedure created.

SQL> exec pasc_to_char('guojun');
103
103117
103117111
103117111106
103117111106117

PL/SQL procedure successfully completed.

二、

SQL> select to_char(ascii('nihao'),'XXXX') from dual;

TO_CH
-----
6E

SQL> select to_char('nihao','XXXX') from dual;
select to_char('nihao','XXXX') from dual
*
ERROR at line 1:
ORA-01722: invalid number

得出结论：只有ASCII编码和十六进制间能相互转换，而VARCHA2与十六进制间不能转换

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11423276/viewspace-973999/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11423276/viewspace-973999/