INSERT INTO lob_table SELECT column_list TO_LOB long_column FROM long_tableOracle 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_list | A list of non-LONG columns |
TO_LOB | The required function |
long_column | The LONG or LONG RAW column that is to be converted |
FROM | Required keyword |
long_table | The original table containing the LONG or LONG RAW column |