Hello all. I have a question about updating a LONG datatype
column in Oracle 8.1.7.
I have a STUDENT table like:
student_id INTEGER PK
student_comment s LONG
I want to execute a command like this:
UPDATE student SET student_comment s = student_comment s || 'some new
comments' WHERE student_id = 1;
I am getting an error message indicating incompatible data types.
Do I have to do some sort of conversion/cast to add my new
comments to the existing ones ?
Thanks in advance
column in Oracle 8.1.7.
I have a STUDENT table like:
student_id INTEGER PK
student_comment s LONG
I want to execute a command like this:
UPDATE student SET student_comment s = student_comment s || 'some new
comments' WHERE student_id = 1;
I am getting an error message indicating incompatible data types.
Do I have to do some sort of conversion/cast to add my new
comments to the existing ones ?
Thanks in advance