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 |