Re: address quotation mark

replace(column1, '''', ' ')

In string, <single quoteation><single quotation> means <single quotation>.

ChunHua wrote:
>
> Hi,
>
> I would like to how to address the quotation mark, both single and double,
> in pl/sql.
> For instance, using replace function to remove the single quo mark in
> column1:
> replace(column1,''',' ' ), of course, this will cause an error. So how?
> Thanks in advance.

--
Mitsunori Ishikawa