Re: Use of the quote / apostrophe in text fields
- From: <sfaroult@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Mar 2004 05:28:55 EST5EDT
I know of no other means than a systematical and ugly REPLACE
(COL, '''', '''''').
SF
> Many of our data fields require use of a quote embedded within the text
> field, most particularly for proper names (eg 'A'MHOINE PSAMMITE', just to
> give you a taste of Scottish geological terminology!)
>
> This can prove troublesome where autogenerated update scripts are used, in
> which the value of the field is retrieved back into a quote-delimited
> string.
>
> Is anyone aware of a means of redefining the field delimiter from a quote to
> some other arbitrary character in SQL?
>
> thanks,
>
> peter
> edinburgh
>
>
-- Oracle scripts, papers and DBA Tools --
-- Oriole Corporation --
-- http://www.oriole.com/ --
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
