Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: a string contains an ampersand
On Tue, 24 Mar 1998 21:59:30 GMT, lien_at_cs.umb.edu (jlk) wrote:
>I want to insert a string into a table such as:
> Mary & Scott
>the string contains an ampersand &.
>
>The & in oracle is a type for prefixes variable.
>
>How do I solve this problem, I have to insert the string which contains an &.
>
>thanks
>
Hi,
try SET SCAN OFF.
HTH
Peter
-- Peter Schneider peter.schneider_at_okay.netReceived on Tue Mar 24 1998 - 00:00:00 CST