Yep, but only
if you’re on 10g. You can change the quote delimiter to whatever string
you want.
Pete
"Controlling
developers is like herding cats."
Kevin Loney,
Oracle DBA Handbook
"Oh no,
it's not. It's much harder than that!"
Bruce Pihlamae,
long-term Oracle DBA
-----Original
Message-----
From:
oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robson, Peter
Sent: Monday, 15 March 2004 9:00
PM
To: 'oracle-l@xxxxxxxxxxxxx'
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?
*********************************************************************
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@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
-----------------------------------------------------------------