decrease column size

[ArjunRaghu]

You can easily reduce the size of a column in oracle without affecting the data in the modifying column.

SQL> alter table column

example:

SQL> alter table employee column emp_name varchar2(12);

If your data size in the modfying column is greater than your reduced new size then it won't change rather it will display an error message "cannot decrease column length because some value is too big".