Re: Use of the quote / apostrophe in text fields

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Mon, 15 Mar 2004 10:54:07 -0700
Message-id: <4055EDBF.EF0CA3BB@sun.com>

I don't know how much this would help, but you might be able to use the CHR() function.

SQL> insert into t1 values ('A'||chr(39)||'MHOINE PSAMMITE');

1 row created.

SQL> select * from t1;

QUOTE_STRING

A'MHOINE PSAMMITE "Robson, Peter" wrote:

> 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,peteredinburgh
>
>
> ********************************************************************
>
> This e-mail message, and any files transmitted with it, are
> confidential and intended solely for the use of the addressee.
> If
> this message was not addressed to you, you have received it in
> error
> and any copying, distribution or other use of any part of it
> is
> strictly prohibited. Any views or opinions presented are
> solely those
> of the sender and do not necessarily represent those of the
> British
> Geological Survey. The security of e-mail communication cannot
> be
> guaranteed and the BGS accepts no liability for claims arising
> as a
> result of the use of this medium to transmit messages from or
> to the
> BGS. . http://www.bgs.ac.uk
>
> ********************************************************************

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 15 2004 - 11:50:42 CST