'''joy'''
-Original Message-
Sent: Monday, June 18, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please see the
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
Harvinder:
Use two single quotes in a row ('') for a single tick.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
From: Harvinder Singh [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
Reply-To: [EMAIL PROTECTED]
Date: Mon, 18 Jun
Harvinder,
if you do
select chr(39) from dual, you will get the answer as a '
Therefore, you could do
select chr(39)||1||chr(39) from dual to get:-
'1'
so now you can help your self.
for future when ever you need to find the ascii of such characters, do:-
select ascii('?') from dual;