You have a table with the following definition:
CREATE TABLE long_tab
(id NUMBER);
long_col LONG)
You need to convert the LONG_COL column from a LONG data type to a LOB data type. Which
statement accomplish this task?
A.
ALTER TABLE long_tab
MODIFY (LONG_COL CLOB);
B.
EXECUTE dbms_lob.migrate(long_tab, long_col, clob)
C.
EXECUTE dbms_manage.lob.migrate(long_tab, long_col, clob)
D.
EXECUTE utl_lob.migrate(long_tab, long_col, clob)
E.
EXECUTE utl_manage_lob.migrate(long_tab, long_col, clob)
Explanation:
In Oracle 9i, a LONG column in a Table can be migrated to a LOB column using the ALTER
TABLE statement. The syntax is:
ALTER TABLE <schema>.<table name>
MODIFY <long column name> {CLOB | BLOB | NCLOB}In Oracle 8i you must use the TO_LOB function to migrate an existing LONG column to a LOB column.
This function can only be used in the SELECT list of a subquery in an INSERT Statement.