ORA-22858: invalid alteration of datatype

ORA-22858: invalid alteration of datatype

<span style="font-size:22px"><h2>ORA-22858 invalid alteration of datatype</h2></span> ORA-22858 invalid alteration of datatype Change the data type of column 3 from VARCHAR2 (50) to CLOB while keeping the column order correct. Step 1: Add Column Alter Table Test_tble Add(Paragraph2 Clob); --step 2: Update Column Update Test_tble Set Paragraph2 = Paragraph Step 3: Drop Old Name Column Alter Table Test_tble Drop (Paragraph); --Step 4: Rename The New Column To The Previous Name Alter Table "Test_tble" Rename Column "Paragraph2" To "Paragraph" 🔗 Demo Application-             URL- Demo Application             Username - demo, Pass- demo I hope everyone will like it. Please watch the full video, Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefu…