Re: Something Weird with Sqlplus

It should read:

I know that SQL*PLUS!!! uses and "&" as a place holder.

The substitution variable is a sql*plus feature, NOT a SQL feature. Use set define off to disable substitution variables.

Hth,

Sybrand Bakker, Oracle DBA

mparish <mparishNOmpSPAM_at_inlogic.com.invalid> wrote in message news:01ba24e0.57562a53_at_usw-ex0106-048.remarq.com...
> I'm running Oracle 8.0.5 on NT4.0.
>
> If I execute a INSERT statement with a alphanumeric field containing an
> "&" (ie: insert into table1 (field1) values('STONE & COX');), using
> SQLPLUS, it will respond with "Enter value for cox:".
>
> I know that SQL uses and "&" as a place holder and obviously that's
> what it is doing here. Here's the weird part! If open the SQL
> Worksheet in Enterprise Manager and enter the same command it will work.
>
> What is happening? I'm I nuts? Please Help?
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Feb 17 2000 - 00:00:00 CET