可以通过很多种方式,以下给个实例,比如需要向表中某字段插入&开头的字符:SQL> conn test/test Connected.SQL> create table t2(id1 varchar2(32),name varchar2(32));Table created.SQL> insert into t2(id1,name) values('a','1');1 row created.SQL> insert into t2(id1,name) values('&a','2'); Enter value for a: old 1: insert into t2(id1,name) values('&a','2') new 1: insert into t2(id1,name) values('','2')1 row created.SQL> insert into t2(id1,name) values('&'||'a','3');1 row created.SQL> select * from t2;ID1 NAME -------------------------------- -------------------------------- a 1 2 &a 3
出现无效列名提示
双引号不行啊
Connected.SQL> create table t2(id1 varchar2(32),name varchar2(32));Table created.SQL> insert into t2(id1,name) values('a','1');1 row created.SQL> insert into t2(id1,name) values('&a','2');
Enter value for a:
old 1: insert into t2(id1,name) values('&a','2')
new 1: insert into t2(id1,name) values('','2')1 row created.SQL> insert into t2(id1,name) values('&'||'a','3');1 row created.SQL> select * from t2;ID1 NAME
-------------------------------- --------------------------------
a 1
2
&a 3
create table TEST2
([wps] varchar(20));
是这个意思吗
还是谢谢各位帮助