| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Use of the quote / apostrophe in text fields
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_at_audit-commission.gov.uk]
> Sent: Monday, March 15, 2004 10:24 AM
> To: oracle-l_at_freelists.org
> 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_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
> -----------------------------------------------------------------
>
-- 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:46:43 CST
 |
 |