Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: single quote
> Eg. insert into COMPANY values ( 'SAN'ANGLE', ... )
use:
insert into COMPANY values ('SAN''ANGLE', ...)
instead. the doubling of the quote gets stored as one quote in the database.
-- Stephen Cheung 512-916-8324 anytime. stephen_at_cyberservices.comReceived on Wed Nov 05 1997 - 00:00:00 CST