RE: Storing '&' in the database

Metalink article Note: 1009415.6

If you do not have access to Metalink, here's the skinny;

SET DEFINE OFF OR CHANGE THE SUBSTITUTION CHARACTER OR USE ESCAPE \ Workaround 1:
Turn off the substitution variable (&) by executing "SET DEFINE OFF" or by executing "SET SCAN OFF" in SQL*Plus.

Workaround 2:
Use the SET DEFINE SQL*Plus command to set the substitution character from an
ampersand (&) to any other non-alphanumeric non-white space character (such as
an asterisk, percent symbol, or pound sign). Leave DEFINE ON and SCAN ON to process substitution variables.

Workaround 3:
SET ESCAPE ON (Leave the DEFINE as '&' and SCAN ON). Preceed the special character with the escape backslash \.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sridhar Moparthy
Sent: Friday, November 10, 2000 1:19 PM
To: Multiple recipients of list ORACLE-L Subject: Storing '&' in the database

Hi All ,

Do you know how to store data that contain '&' in to a table.

Thank You in advance. ,
Sridhar Moparthy, Received on Fri Nov 10 2000 - 12:40:49 CST