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

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

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

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