Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how do I put a & in a varchar2?

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

From: Michael A. Rife <MRife_at_admin.usf.edu>
Date: 1997/09/29
Message-ID: <60o94d$k9c$1@news.usf.edu>#1/1

You could just:

  SQL> set scan off

You need to look in the SQL*Plus book.

In article <60h71r$2pn_at_news.boca.net>, cleve_at_cbcsf.org says...
>
>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?
Received on Mon Sep 29 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US