Re: PLSQL and escaping the ' character

it works with replace too
as example:
select replace ('"111","abc","def","ghi"','"','''') from dual

this replaces all " with '

Mark Wenham wrote:

> Can anybody help
>
> I am using UTL_FILE.GET_LINE to read a comma delimited string from a file eg
> "111","abc","def","ghi" etc etc etc
>
> I figure that I can use the TRANSLATE function to change the " to a ' and
> then submit the whole line as an insert statement using
> DBMS_SQL. I am having trouble with the syntax of escaping the ' in the
> function - can anybody give me some pointers.
>
> Thanks
> Mark
Received on Mon Jul 02 2001 - 17:07:39 CEST