1. 查询出’&’字符的ascii值 select ascii('&') from dual; --38 2. 将ascii值代替&,放入字符串中(注意使用连接符) insert into testtable values ('abc'||chr(38)||'def'); select 'abc'||chr(38)||'def' from dual;