-----Original Message-----
From: Ernesto Daniel Portela
[mailto:oracledba-ezmlmshield-x29442865.[Email address protected]
Sent: Friday, September 29, 2006 6:49 AM
To: LazyDBA Discussion
Subject: Insert character '
use the binary value for the base character set...
for example...

insert into t1 (val1) values (chr(39));

Hi All

I need insert this character in a string: '
(simple quote)

INSERT INTO T1 SET VAL1='''

How I can do this??

Thanks

Ernesto Portela


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.



Oracle LazyDBA home page