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 -> how do I put a & in a varchar2?

how do I put a & in a varchar2?

From: David Kramer <Dskramer_at_concentric.net>
Date: 1997/09/17
Message-ID: <Pine.SUN.3.96.970917182236.938H-100000@galileo.cris.com>#1/1

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

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?

TIA.


DDDD    David Kramer                        dskramer_at_concentric.net   
DK KD                           http://www.concentric.net/~dskramer
DKK D
DK KD "Time's fun when you're having flies." -- Kermit the Frog DDDD Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

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