Syntax for an UPDATE statement (9i), contains a single-quoted value

[tradle]

All -

I'm trying to update a string column with the following:

UPDATE table
SET column = ((Data = 'This'))
WHERE condition = That;

I know that I have to place something on the outside of the ((Data = 'This')) in order to have Oracle read it properly. I'm updating a string column, and every variation I try ends with an error.

This is an easy one, I know, but my mind is failing me at the moment. HELP.

Thanks,
Tim

 

[danmul]

do u want the value ((Data = 'This'))in the column, if so then
set col_name = '((Data = ''This''))'

 

[sem]

To make the previous answer more clear: each quote within string literal should be doubled.

Regards, Dima

http://seminihin.narod.ru