RE: Use of the quote / apostrophe in text fields

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 15 Mar 2004 10:23:54 +0000
Message-Id: <s0558459.029@bristol21.bristol.ac>

In sql, or in sqlplus?

If the latter how about set colsep # (or whatever).

If the former how about replacing

Select col1,col2,col3....
With

Select col1||'#'||col2||'#'||col3 ....

Two quick thoughts rather than actually work on a Monday morning.

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805

> -----Original Message-----
> From: pgro_at_bgs.ac.uk
> Sent: 15 March 2004 09:59
> To: oracle-l_at_freelists.org; pgro_at_bgs.ac.uk
> Subject: Use of the quote / apostrophe in text fields
>
>
> 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
>
>
>
> *********************************************************************
> 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
> *********************************************************************
>
>

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

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 - 04:22:42 CST