[Oracle] 關閉替代字元(Substitution Variables) "&" 掃描

摘要:[Oracle] Substitution Variables

當新增紀錄時若欄位內容有 "&" 符號,可以先執行 SET DEFINE OFF  防止替代字元掃描而造成無法Insert。

refer to:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch5.htm
http://www.oracle-base.com/articles/misc/LiteralsSubstitutionVariablesAndBindVariables.php