Re: how do I put a & in a varchar2?

David Kramer wrote in article ...

>This sounds stupid, but I can't find this in three different Oracle books.

Nope, it is a legitimate question.

>If I use a & in my insert, it thinks I'm defining a variable. In fact,
>I'm inserting a URL into a field in my database. How do I escape it?

You have to concatenate the '&' character for it to work as follows:

    INSERT INTO your_table VALUES
('http://www.test.com/~kramer/test.html?'||'&'||'submit')

That is, you have to split up the URL where the '&' is by itself and concatenated with the other parts of the URL.

Hope this helps
=-=-=-=-=-=-=-=-=-=-=-=-=-=
Cleve. Received on Fri Sep 26 1997 - 00:00:00 CDT