Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ampersand embedded in a string
Hi,
It is possible to create a table with a column like this.
Create table t1("col1&" varchar2(10));
The only thing u need is that u will have to refer that column always in Quotes.
PS Narayanan
In article <yYHu3.2655$8X1.292099_at_PM01NEWS>,
"arvind" <arvind_at_mciworld.com> wrote:
> set define off
> or
> set define (some other character)
> Narendra Puppala wrote in message <7pd57q$6s4$1_at_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.
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 23 1999 - 19:05:14 CDT