Day: January 19, 2021

Converting column data type from clob to varchar?

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?