Re: &-Operator in Literal

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 23 Sep 1999 09:31:00 -0400
Message-ID: <UyvqN1vLbCfZJUcKfSZhQdzjAge=@4ax.com>

A copy of this was sent to Oliver Schoenwaelder <schoeni_at_de.infogrames.com> (if that email address didn't require changing) On Thu, 23 Sep 1999 14:43:18 +0200, you wrote:

>Hi,
>
>when executing the statement: "insert into <TABLE> (<COLUMN>) values
>('Company & Co.');" sqlplus wants a value for the parameter "co". I
>tried using "\&" and "&&" to make sql understand to use & as a
>character, not an operator. How does it work?
>
>Thanks,
>
>Oliver

the & is the default 'macro substitition variable delimiter' in sqlplus.

You can:

SQL> set define off

to disable this.

SQL> set define @

to change it to an @ sign (or whatever character), or

SQL> set scan off

to disable it as well....

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 23 1999 - 08:31:00 CDT