Re: How can I use '&' in VARCHAR2 fields ?

Just like that:
INSERT INTO mytlb (myfield) VALUES ('/mypage.asp?par1=345&par2=234');

Just make sure that SQL*Plus understands the & isn't s special character,
if that's what you use:
set define off
or:
set define <an other character, i.e. ~>

rdf wrote:

> Hi,
>
> I think the subject is all...!!!
> My example:
> INSERT INTO mytlb (myfield) VALUES ('/mypage.asp?par1=345&par2=234')
>
> I hope in your help.
> Thanks.
  Received on Thu Oct 19 2000 - 13:55:59 CDT