how to modify the size of a column

Question

I created the table Test Project2 in Oracle SQL Developer  After that I realized that the column proj name is of a small size  so I decided to modify the column using the follwoing statement  ALTER TABLE TEST PROJECT2 MODIFY proj name VARCHAR2 300     but for some reason Oracle SQL Developer underscores the semi-colon with red and I do not what is mistake and how to correct it  Test Project2   CREATE TABLE Test Project2   proj id number 30   proj name VARCHAR2  30   proj desc VARCHAR2 300

User · Answer

If you run it  it will work  but in order for SQL Developer to recognize and not warn about a possible error you can change it as    ALTER TABLE TEST PROJECT2 MODIFY  proj name VARCHAR2 300

User · Answer

Regardless of what error Oracle SQL Developer may indicate in the syntax highlighting  actually running your alter statement exactly the way you originally had it works perfectly   ALTER TABLE TEST PROJECT2 MODIFY proj name VARCHAR2 300     You only need to add parenthesis if you need to alter more than one column at once  such as   ALTER TABLE TEST PROJECT2 MODIFY  proj name VARCHAR2 400   proj desc VARCHAR2 400

User · Answer

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

[oracle] how to modify the size of a column

Examples related to oracle

Examples related to oracle-sqldeveloper

Examples related to alter-table