Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Storing '&' in the database

RE: Storing '&' in the database

From: Channa, Santhosh, SITS <schanna_at_att.com>
Date: Mon, 13 Nov 2000 14:53:24 -0500
Message-Id: <10679.121925@fatcity.com>


I use 'AT'||CHR(38)||'T TAX' to store the value "AT&T" in the database.

Santhosh Channa
> -----Original Message-----
> From: gregory.t.norris_at_mail.sprint.com
> [SMTP:gregory.t.norris_at_mail.sprint.com]
> Sent: Friday, November 10, 2000 2:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Storing '&' in the database
>
> Assuming you're going through sqlplus, do "set define off" first.
>
> -----Original Message-----
> Sent: Friday, November 10, 2000 12:19 PM
> To: ORACLE-L
>
>
> Hi All ,
>
> Do you know how to store data that contain '&' in to a table.
>
> Thank You in advance. ,
> Sridhar Moparthy,
> (561) 750 - 2582.
Received on Mon Nov 13 2000 - 13:53:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US