Re: how do I put a & in a varchar2?

David Kramer wrote:
>
> 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.
If you are doing this from SQL*Plus, type:

SET SCAN OFF before executing the insert statement.

John. Received on Fri Sep 19 1997 - 00:00:00 CDT