RE

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 13 Oct 2000 10:58:53 +0200
Message-Id: <10648.119154@fatcity.com>

Suzy,

translate(..., '''', '''''')

I don't think that you have to worry about anything but signe quotes.

-- 
Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:    +44  (0) 7050-696-449 
  Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------


> 

> One of our developers wants to use INSERT to populate a varchar2 column

> with html data.  Obviously the html contains lotsa special characters,

> like single quotes, so INSERT fails when it encounters a single quote

> within the html being inserted.   Any way to get around this?  

>

Received on Fri Oct 13 2000 - 03:58:53 CDT