From time to time, you might run into some tasks like converting column data type. Oracle has provided the feature with "alter table" statement with some limitations -- for example, you cannot change a column type from clob to varchar2 with it: SQL> desc jli_0104 Name Null? Type ------------------ -------- ------------ IUID CLOB SQL> ALTER … Continue reading Converting column data type from clob to varchar? →