学步园

(方法一)
例:插入特殊字元'&'
SQL> SHOW DEFINE      
define "&" (hex 26)    <---  DEFINE的default值是 ‘&’
SQL> SET DEFINE OFF
SQL> SHOW DEFINE
define OFF
SQL> INSERT INTO <table_name> VALUES ('AT&T');
/
1 row created

(方法二)
SQL> SHOW ESCAPE  
escape OFF     <---  ESCAPE的default值是 OFF
SQL> SET ESCAPE ON
SQL> SHOW ESCAPE
escape "/" (hex 5c)
SQL> INSERT INTO temp_table VALUES ('select * from emp where ename = /&1');