Re: Ampersand embedded in a string

From: Narendra Puppala <n_puppala_at_yahoo.com>
Date: Tue, 17 Aug 1999 21:22:45 -0500
Message-ID: <7pd57q$6s4$1@ionews.ionet.net>

Well, it depends on what exactly you need. If you want to have an ampersand as part of your column name, I believe this is not possible.

If you want to have an & embedded as part of the value entered for a column then you can do the following to avoid SQL* PLUS from interpreting the &.

set scan off;

This setting is valid only for your current session.

Nandakumar wrote in message <7pcp5s$oum$1_at_nnrp1.deja.com>...
>Can we include & in a varchar2 field (of a table) without causing a
>problem in queries?
>Any Escape Sequence required before &??
>--
>Nandakumar
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Aug 17 1999 - 21:22:45 CDT