oracle如何插入特殊字符

# 通过插入特殊字符的unicode编码来显示
# 特殊符号的对应编码 http://www.jsons.cn/unicode/上查询


# 系统字符集
[oracle@orcl ~]$ env|grep LANG
LANG=en_US.UTF-8
[oracle@orcl ~]$ export NLS_LANG=american_america.AL32UTF8


# 数据库字符集
SQL> select userenv('language') from dual;


USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8


SQL> create table tab1 (a varchar2(10));


Table created.


SQL> insert into tab1 values(cast(unistr('\2122') as nvarchar2(6)) );


1 row created.


SQL> select * from tab1;


A
----------
™


SQL> insert into tab1 values(cast(unistr('\0026') as nvarchar2(6)));


1 row created.


SQL> select * from tab1;


A
----------
™
&