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


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 England
Received on Sat Nov 11 1995 - 00:00:00 CET

Original text of this message