Re: single quote

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/10/17
Message-ID: <34476C4B.45D3EFEF@gatwick.geco-prakla.slb.com>#1/1

I'm not exactly clear what you are trying to achieve i.e how is the statement

insert into COMPANY values ( 'SAN'ANGLE', ...) being generated

however I believe something along the lines of

1* select replace('SAN''ANTONIO','''','''''') from dual SQL> / REPLACE('SAN

---

SAN''ANTONIO may be what you are looking for where the 'SAN''ANTONIO' in the select clause above represents the field in your table (I have had to escape the internal ' for my example).
What I am actually doing is turning a column that contains an embedded ' into output that contains '' . You could then use this output in a insert statement.
I assume the syntax:

insert into tablea(columna)
select columnb from tableb;

is not suitable for your application?

Hope this helps,

Ian Received on Fri Oct 17 1997 - 00:00:00 CDT