Re: Inputting special characters into a varchar field

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 05 Apr 2005 23:10:40 GMT
Message-ID: <QVE4e.17805$zl.15420@newssvr13.news.prodigy.com>

Rauf Sarwar wrote:

> 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
>

It's also good to know how to use the CHR() function.

-Mark Bole Received on Tue Apr 05 2005 - 18:10:40 CDT