===========================================================
如何向数据库中插入带有?或者&呢？
===========================================================
作者: 2jliu(http://2jliu.itpub.net)
发表于: 2007.03.07 13:43
分类: 回味&引申
出处: http://2jliu.itpub.net/post/21805/269107
---------------------------------------------------------------
发表于: 2007.03.07 13:43
分类: 回味&引申
出处: http://2jliu.itpub.net/post/21805/269107
---------------------------------------------------------------
SQL> insert into t (id) values(chr(63));
1 row inserted
SQL> insert into t (id) values(chr(38));
1 row inserted
SQL> select * from t;
ID
--------------------
?
&
SQL> insert into t values ('aa'||chr(63)||'bb'||chr(38)||'c');
1 row inserted
SQL> select * from t;
ID
--------------------
?
&
aa?bb&c
select ascii('&') from dual;
way2:
?没有问题，&可以set define off关闭
set define off
insert into tmp values('aa?a&a');
