ORA-22858

How to Modify VARCHAR2 to CLOB of a Column

by Ed Chen
February 24, 2021July 2, 2023
2 Comments

Data Type Conversion There're several major data types built in Oracle. Character Numeric Datetime LONG RAW LOB (Large Object) In each major data types, minor… Read More »

How to Resolve ORA-22858: invalid alteration of datatype

by Ed Chen
February 23, 2021May 19, 2022

ORA-22858 When we tried to convert VARCHAR2 to CLOB, we got ORA-22858. SQL> alter table hr.locations modify (city clob); alter table hr.locations modify (city clob)… Read More »

JavaScript is not enabled. Please enable it and reload the page.