Re: Escape character for & in strings.

My most humblest apologies for being ambiguous...Everyone has been so kind as to offer this solution. What I need to do is see if that will work through the code. As noted, I'm not trying to do this in a sqlplus session, I'm connecting from another piece of software... Thank you very much for your time and response! Cindy

Kenneth C Stahl wrote:

> Oh, is that what you want to know. You should have said so from the start.
>
> Simply enter the following command in your script before you execute the
> sql:
>
> set define off
>
> As long as you are not using substitution variables in your sqlplus script
> you'll be ok. If you are, then simply set define to some other innocuous
> character that doesn't have a significane to Oracle.
>
> Ken
>
> "C." wrote:
>
> >
> > insert into icecream VALUES ('Ben & Jerry''s');
> >
> > what happens is:
> > Enter value for jerry:
> >
> > Not what I want to happen. I have code that is trying to do the
> > insert, so
> > I run each string through some checker code looking for the apostrophe
> > and it
> > alters the string to contain two single quotes, but what about the &
> > character.
> >
> > Now, the following insert statement would work:
> > insert into icecream values ('Ben ' || '&' || ' Jerry''s');
> >
> > I could make my code rewrite the string into that format, but give me
> > a
> > break? Isn't there a better solution?
> >
Received on Sat Jun 26 1999 - 23:31:07 CDT