The TO_LOB is one of the vital Conversion functions of Oracle. It is used to convert a LONG or LONG RAW values to LOB values. The TO_LOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
TO_LOB ( long_column )
Parameters: long_column: It is used to specify the LONG or LONG RAW value to be converted.
Example:
insert into class (lob_column) select TO_LOB(long_column) from students; |
Explanation: Here, the value in the field called long_column will be converted to a LOB value.
