| Rey-Ki |
| Коллеги, не подскажете как переконвертировать тип LONG RAW в тип CLOB? |
В команде INSERT использовать функцию TO_LOB
Purpose
======
TO_LOB converts LONG or LONG RAW values in the column long_column to LOB
values. You can apply this function only to a LONG or LONG RAW column, and only in
the select list of a subquery in an INSERT statement.
Before using this function, you must create a LOB column to receive the converted
LONG values. To convert LONG values, create a CLOB column. To convert LONG RAW
values, create a BLOB column.
You cannot use the TO_LOB function to convert a LONG column to a LOB column in the
subquery of a CREATE TABLE ... AS SELECT statement if you are creating an
index-organized table. Instead, create the index-organized table without the LONG
column, and then use the TO_LOB function in an INSERT ... AS SELECT statement.
See Also:
-- the modify_col_properties clause of ALTER TABLE on
page 12-2 for an alternative method of converting LONG columns
to LOB