Re: oracle

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');

SQL> select * from x;
A

a&b
x&y
m&n

Anurag

<john62_at_electronmail.com> wrote in message news:3D45F110.CE97F14F_at_electronmail.com...
> how do i insert an ampersand into an orable table? this is urgent.
> please reply to my email addy.
>
> --
> ----------------------------------------------------------------
> This message was sent from an Electronmail.com email address.
> Electronmail.com offers 6MB of free e-mail, free news, and more.
> http://www.electronmail.com/
> ----------------------------------------------------------------
>
>
Received on Tue Jul 30 2002 - 04:38:13 CEST