I think I remember that to escape a single quote so that you
can include it in a string, you need to escape a single quote
with a single quote, like this:
inset into Tname values('Gopi''s','20');
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
gopinath r [[EMAIL PROTECTED]] wrote:
> Hai
>
> my problem is to insert a varchar2 datatype which
> contains single quote(') into Oracle table from Perl.
>
> i am using ActivePerl for windows...how to handle this
> problem.
>
> eg. inset into Tname values('Gopi's','20');
> ------
>
> Thanks
> gopi
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
