Alter table table table name modifies the field name varchar2 (length); or

Alter table table table name modifies the field name number (length);

Only bigger.

If you want to make it smaller, you can only rebuild the table, guide the data to the new table, and then discard the old table.