TO_LOB

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


© Copyright SS64.com 1999-2013
Some rights reserved