方法一select ascii('&') from dual;select chr(38) from dual; insert into test(name) values(chr(38))方法二单引号('),将一个单引号变为两个单引号即可insert into test(name) values('''')select * from test where name like '%''%'