PLSQL and escaping the ' character
From: Mark Wenham <markwenham_at_prodigy.net>
Date: Sat, 23 Jun 2001 22:38:39 GMT
Message-ID: <PT8Z6.379$1F.111223009_at_newssvr15.news.prodigy.com>
Date: Sat, 23 Jun 2001 22:38:39 GMT
Message-ID: <PT8Z6.379$1F.111223009_at_newssvr15.news.prodigy.com>
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 Sun Jun 24 2001 - 00:38:39 CEST