Prior to issuing the insert command, issue the following SQL*Plus command:
SET DEFINE $
This changes the define character from & to $.
--
Phillip Bump
Senior Principal Consultant
Oracle Consulting
----------------------------------------------------------------------------
-----------------------------------------------------------------------
The opinions expressed are my own and do not necessarily reflect those of
Oracle Corporation
David Kramer <Dskramer_at_concentric.net> wrote in article
<Pine.SUN.3.96.970917182236.938H-100000_at_galileo.cris.com>...
>
>
> This sounds stupid, but I can't find this in three different Oracle
books.
>
> If I use a & in my insert, it thinks I'm defining a variable. In fact,
> I'm inserting a URL into a field in my database. How do I escape it?
>
> TIA.
>
>
> -------------------------------------------------------------------
> DDDD David Kramer dskramer_at_concentric.net
> DK KD http://www.concentric.net/~dskramer
> DKK D
> DK KD "Time's fun when you're having flies." -- Kermit the Frog
> DDDD
>
>
>
Received on Sat Sep 20 1997 - 00:00:00 CDT
