Quote characters within a quoted string should be doubled/repeated.

For example, to set a character variable to a quote character do something
along the lines of the
following:

value := '''';

The surrounding quotes are the normal text delimiters, while the two inner
quotes identify a single quote character within.
Another example that might make this clearer is:

value := 'Spot is Jack''s dog.';


HTH.
Bill


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------





"Ernesto Daniel
Portela "
<oracledba-ezmlms To
hield-x29442865.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

09/29/2006 08:48 Subject
AM Insert character '










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





Oracle LazyDBA home page