Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem entering data for TEXT type
But he would have had to have known that the ampersand was the problem to
know to search on "ampersand".
"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message
news:8HWRa.2934$634.1702_at_nwrdny03.gnilink.net...
>
> "David Hall" <noone_at_nowhere.com> wrote in message
> news:bf9bhf$m89$1_at_newsg1.svr.pol.co.uk...
> > Hi all
> >
> --snip--
> > The SQL I'm using looks like this:
> >
> > INSERT INTO contact VALUES (4,
> > 'http://www.websitename.com/forums/register.php?s=&action=signup')
> >
> > ...and when I submit it I get a prompt which says
> >
> > "Enter value for action:"
> --snip--
> >
> > Many thanks in advance
> >
> > David
>
> Its a FAQ all right.
> I'll copy paste from my earlier reply (You could have found this yourself
by
> searching for "oracle ampersand")
>
> Choose your way:
> SQL> create table x (a varchar2(10));
> Table created.
>
> SQL> insert into x values ('a'||chr(38)||'b');
> 1 row created.
>
> SQL> set escape on
> SQL> insert into x values ('x\&y');
> 1 row created.
>
> SQL> set escape off
> SQL> set define ^
> SQL> insert into x values('m&n');
> 1 row created.
>
> SQL> select * from x;
> A
> ----------
> a&b
> x&y
> m&n
>
> .... or you can simply: "set define off"
>
> Anurag
>
>
>
>
Received on Fri Jul 18 2003 - 13:18:27 CDT
![]() |
![]() |