Large Objects   «Prev 

TO_LOB

INSERT INTO lob_table
  SELECT column_list
  TO_LOB long_column
  FROM long_table
Oracle TO_LOB

INSERT INTO Required keywords.
lob_table The new table with the LOB data type. This table must exist before using this statement.
SELECT Required keyword
column_listA list of non-LONG columns
TO_LOB The required function
long_columnThe LONG or LONG RAW column that is to be converted
FROMRequired keyword
long_table The original table containing the LONG or LONG RAW column