Hello Harvinder,
If you are doing the insert from SQL*Plus, double up on the
quote. For example:
insert into your table (name) values ('''joy''');
The resulting value will be (quotes included):
'joy'
BTW, this came in handy recently when I went to a web site
(I won't say whose) and tried to search for a term with an
apostrophe in it. The search kept failing with some sort of
string error, so it eventually occurred to me to use a
double-apostrophe where I wanted one. The search then
worked. Obviously some programmer didn't take the
possibility of a user entering an apostrophe into account
when he concatenated everything together to build his SQL
statement.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
Monday, June 18, 2001, 7:25:21 PM, you wrote:
HS> I have a column defined as varchar2......i need to insert name like 'joy' in
HS> it with quote....
HS> how can we insert quote(') to column.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
