running the below statement does not work,
update table set col1 = col1 || 'X' ;
col1 is of CHAR datatype.
the error i'm getting is " value too large". i understand CHAR allocates the specified length as defined. would append not work at all??
could someone please help.