Re: sql*plus INSERT problem
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/11/11
Message-ID: <4829a4$733$1_at_mhadf.production.compuserve.com>#1/1
Date: 1995/11/11
Message-ID: <4829a4$733$1_at_mhadf.production.compuserve.com>#1/1
You can use an ampersand in SQLPLUS by using various combinations of the SQLPLUS SET command, specifically 'SET DEFINE symbol' will change the charcter from an ampersand to the symbol, 'SET DEFINE OFF' will turn off variable substitution altogether, 'SET ESCAPE symbol' will define an escape charater which you use to prefix the ampersand so that it is not take as a variable. Finally 'SET SCAN OFF' should also turn off substitution
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Sat Nov 11 1995 - 00:00:00 CET