Re: Problem entering data for TEXT type

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 18 Jul 2003 18:07:00 GMT
Message-ID: <8HWRa.2934$634.1702@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:07:00 CDT