Re: Inputting special characters into a varchar field

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Apr 2005 09:30:39 -0700
Message-ID: <1112718639.824474.170120@f14g2000cwb.googlegroups.com>

PeterHardy wrote:
> Hi
>
> I need to input some special characters into a varchar field like &
or
> #. Can anyone help and let me know the correct syntax to let me do
> this via a sql statement.
>
> Thanks

SQL> create table foo (test_ varchar2(50));

Table created

SQL> set define off
SQL> insert into foo values ('~`!@#$%^&*()-_+={}[]|\/?<>');

1 row inserted

SQL> select * from foo;

TEST_

---

~`!@#$%^&*()-_+={}[]|\/?<>

SQL> Note "set define off" to disable &

Regards
/Rauf Received on Tue Apr 05 2005 - 11:30:39 CDT