SyntaxFix
Write A Post
Hire A Developer
Questions
This was done using Toad for Oracle 12.8.0.49
ALTER TABLE SCHEMA.TABLENAME MODIFY (COLUMNNAME NEWDATATYPE(LENGTH)) ;
For example,
ALTER TABLE PAYROLL.EMPLOYEES MODIFY (JOBTITLE VARCHAR2(12)) ;