Alter table column size in Oracle
In this post, we will learn how to modify the size of an column in an Oracle table. It’s easy to alter the column size using the
ALTER TABLE MODIFY statement.
Sometimes the column value will exceed from which we defined while creating the table. So in that case we need to update the size of the column again.
ALTER TABLE table_name MODIFY column_name column_type;
Lets take the table as
EMPLOYEES for understanding. To know the existing size of an each column you can describe the table like below,
The result will be like this,
Now we going to alter the size of the
EMP_NAME column, you can write a query like in the below code snippet.
ALTER TABLE EMPLOYEES MODIFY EMP_NAME VARCHAR2(50); DESC EMPLOYEES;
Happy Querying 🙂