Re: sql*plus and using & character to prompt for input; can I escape it?
From: Joe Ramey <ramey_at_jello.csc.ti.com>
Date: 1996/06/20
Message-ID: <x6688mv4fv.fsf_at_jello.csc.ti.com>#1/1
Date: 1996/06/20
Message-ID: <x6688mv4fv.fsf_at_jello.csc.ti.com>#1/1
In article <x6afxzv65g.fsf_at_jello.csc.ti.com> ramey_at_jello.csc.ti.com (Joe Ramey) writes:
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:
Thanks for any explanation you can provide.
I've been given another answer now too by several people:
set scan off
This seems to work just fine.
Joe Received on Thu Jun 20 1996 - 00:00:00 CEST