如下为转载,感觉原创作者,因为是以前记录的笔记,转载链接未记录。
for example
insert into t values ('R&D search thing');
这样在plsql/dev 里面运行就插不进去,问下有撒好的解决办法没有?
-------------------------------------------------------------------------------------
SQL> create table test (id number,c1 varchar2(200));
Table created.
方法1:
SQL> insert into test values(1,'R'||'&'||'D search thing');
1 row created.
SQL> set linesize 200
SQL> col c1 for a30
SQL> select * from test;
ID C1
---------- ------------------------------
1 R&D search thing
方法2:
SQL> insert into test values(2,'R'||chr(38)||'D search thing');
1 row created.
SQL> select * from test;
ID C1
---------- ------------------------------
1 R&D search thing
2 R&D search thing
方法3:
SQL> set define off
SQL> insert into test values(3,'R&D search thing');
1 row created.
SQL> select * from test;
ID C1
---------- ------------------------------
1 R&D search thing
2 R&D search thing
3 R&D search thing