Convert LONG values to CLOB or NCLOB values or convert LONG RAW values to BLOB values
Syntax to_lob(long_column) Key long_column A LONG or LONG RAW value.
Before using this function, you must create a LOB column to receive the converted data. Create either a character CLOB or a Binary BLOB column.)
Examples
Use as part of an "INSERT INTO … SELECT…" subquery.
SQL> insert into products (product_id, description_lob)
select prod_id, TO_LOB(description_long)
from item_catalogue;
Related
TO_CHAR - Convert to character String
TO_CLOB - Convert character or NCLOB values to the database character set.
TO_NUMBER - Convert to numeric format
Oracle SQL Functions