insert 脚本里面含有&怎么处理？？

如下为转载，感觉原创作者，因为是以前记录的笔记，转载链接未记录。

 

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