Oracle escape & amp; Analysis

Oracle escape & Analysis of insert into table1 (ID, DESCRIPTION) values (1, '/Action. do? Method = getA & iframe = true '); when inserted in pl/SQL, iframe is regarded as a variable and changed to the following form: insert into table1 (ID, DESCRIPTION) values (1, '/Action. do? Method = geta' | '&' | 'iframe = true'); Appendix: Escape of www.2cto.com &. There are two methods to remove this function: A. Escape Character: SQL> set escape \ SQL> insert into table values ('\ & aaaaa'); SQL> select * from mptlog_day t where url like' % \ & t = % '; then add \ for example \ & B in front of & and disable this function SET DEFINE OFF;