Re: sql*plus and using & character to prompt for input; can I escape it?

Joe Ramey (ramey_at_jello.csc.ti.com) wrote:
: We have an SQL statement that looks something like this:
 

: INSERT INTO TMS VALUES ('Crafts & Co.');
 

: When I run this through sqlplus (V 7.2.2.3.0 if it makes any
: difference) it says:
 

: Enter value for co:
 

: and waits for input. Now, I understand that this is a feature that
: allows a script to prompt the user for the value of a variable. My
: question is: how do I prevent this from happening? What is the
: correct way to escape the special meaning of the & character here?
: Why are the single quotes not enough?
 

: I'm told that the SQL client on NT doesn't behave the same way
: (meaning that the & in this context doesn't prompt the user for
: anything) but haven't verified this myself.
 

: Thanks for any explanation you can provide.
 

: Joe

Try:

        Set define off

Srinivasa Kunamneni Received on Fri Jun 21 1996 - 00:00:00 CEST