How can I update a LONG datatype?

[gtarrant]

Is there a way to do this within an sql script?

Here's what I'm dealing with:

PROD SQL> /
update ps_position_data set descrlong = descr where descrlong <= ' '
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

Thank you for your help.

 

[HimanB]

Hi,
You can update a long column but it cannot be used in the WHERE clause.

Here is an example how to update a long column:

SQL> create table t1(a number,b long);

Table created.

SQL> insert into t1 values(1,'This is long');

1 row created.

SQL> commit;

Commit complete.

SQL> update t1 set b='This is updated long' where a=1;

1 row updated.

SQL> commit;

Commit complete.

SQL>

HTH
Regards
Himanshu