Re: Problem entering data for TEXT type

Ah-huh! Thank you kindly

David

"JJ Reynolds" <jjrjunk_at_adelphia.net> wrote in message news:gCWRa.4886$KZ.1749200_at_news1.news.adelphia.net...
> Before issuing your statement, in SQL*Plus, enter the command
> set define off
>
> SQL*Plus treats the & character as the start of a varialbe name. Set
> define off disables this behavior.
>
>
>
> "David Hall" <noone_at_nowhere.com> wrote in message
> news:bf9bhf$m89$1_at_newsg1.svr.pol.co.uk...
> > Hi all
> >
> > This might be an FAQ question, so apologies if it's something very
> > fundamental. I've looked through the Oracle documentation, and spent
some
> > considerable time scanning Google Groups, but I haven't found anything
> that
> > deals specifically with the problem that I'm having.
> >
> > One of my tables has a 'URI' column of TEXT type - and I'm having
> > difficulties with some of the values that I'm trying to enter from
> SQL*Plus
> > under Oracle 8.0 Personal Edition. For example, one of the URL's looks
> like:
> >
> > http://www.websitename.com/forums/register.php?s=&action=signup'
> >
> > 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:"
> >
> > If I just press [return]:
> >
> > old 2: (4,
> > 'http://www.websitename.com/forums/register.php?s=&action=signup')
> > new 2: (4,
> 'http://www.websitename.com/forums/register.php?s==signup')
> >
> > ...with the '&action' part removed. Can someone explain what's going on
> > here? Do I need to escape any '&' string segments somehow?
> >
> > Many thanks in advance
> >
> > David
> >
> >
> >
> >
>
>
Received on Fri Jul 18 2003 - 13:15:48 CDT