Thanks for the thought, Neil, but it won 't work. Tried that ages ago. We are
talking about SQL*Plus, incidentally.
peter
edinburgh
> -- --Original Message-- --
> From: Niall Litchfield [mailto:n-litchfield@(protected)]
> Sent: Monday, March 15, 2004 10:24 AM
> To: oracle-l@(protected)
> Subject: RE: Use of the quote / apostrophe in text fields
>
>
> 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@(protected)
> > Sent: 15 March 2004 09:59
> > To: oracle-l@(protected); pgro@(protected)
> > 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@(protected)
> 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
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
