RE: Inserting an ampersand (&)

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 Paul van
> Dijken
> Sent: Monday, November 20, 2000 10:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Inserting an ampersand (&)
>
>
> I know I should know, but I can't remember and I can't find it in the FM.
>
> How do I insert an & sign into a table like .....values('mothers &
> daughters') ??
>
> Thanx
> Paul
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul van Dijken
> INET: paul.vandijken_at_sema.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Nov 20 2000 - 13:13:16 CST