TO_LOB function in oracle to convert LONG or LONG RAW values to LOB values.

By Santhosh N

This explains how to convert LONG or LONG RAW values to LOB values.

There is a conversion function in oracle by the name, TO_LOB which converts LONG or LONG RAW values to LOB values. This is used to convert the columns of type Long or Long Raw types to lob types.

Syntax: TO_LOB(longValue)

Here longValue is a LONG value or LONG RAW value.

Related FAQs

RAWTOHEX function in oracle to convert a raw value to hexadecimal value.
This explains how to convert a raw value to hexadecimal value in oracle.
ROWIDTOCHAR function in oracle to convert a rowid to varchar2 type.
This explains how to convert a rowid to varchar2 type in oracle.
CHARTOROWID function in oracle to convert any char, varchar2, nchar or nvarchar2 to a rowid
This explains how to convert a char, varchar2, nchar or nvarchar2 value to rowid of a table in oracle database
Convert multi-byte and single-byte characters in Oracle using TO_SINGLE_BYTE
This explains how to convert the both multi-byte and single-byte characters in oracle string to single-byte characters.
Convert string to an interval Day to Second type in oracle using TO_DSINTERVAL function
This explains how to convert the string to an interval Day to Second type in oracle.
Convert number to an interval year to month literal in oracle using NUMTOYMINTERVAL function
This explains how to convert the given number to the interval year to the month literal in oracle
TO_LOB function in oracle to convert LONG or LONG RAW values to LOB values.  (2229 Views)