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 hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, 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 hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................

Post a Comment

Hlo Sir

Previous Post Next Post