Updating LONG columns

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dave Pylatuk

    Updating LONG columns

    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


Working...