Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how do I insert O'Hare value ? ie how do I escape the
With two consecutive apostrophes. Not a double apostrophe and
not an escape clause. Escape is an argument in a where clause.
Ex. Insert into my_table
values('D''Onofrio');
This inserts the string D'Onofrio.
Hth,
Wayne Johnston
DBA
From: Carmen Rusu <crusu_at_clearcommerce.com> on 08/08/2000 07:46 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Wayne M Johnston/BCBSO/TBG)
Subject: how do I insert O'Hare value ? ie how do I escape the apostrophe
Hi Oracle gurus,
How do I escape the apostrophe character in an insert statement ?
Thanks,
Carmen Rusu
Oracle DBA
-- Author: Carmen Rusu INET: crusu_at_clearcommerce.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Aug 08 2000 - 09:37:07 CDT