Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem entering data for TEXT type

Re: Problem entering data for TEXT type

From: Alan <alan_at_erols.com>
Date: Fri, 18 Jul 2003 14:18:27 -0400
Message-ID: <bf9dle$coap0$1@ID-114862.news.uni-berlin.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US