How to alter a table in Oracle to modify multiple column definition

Oracle alter multiple columns
----------------

To alter a single column in Oracle, the syntax is as below:

alter table
   table_name
modify
   column_name  datatype;

If you want to modify multiple columns, use below syntax:

alter table
   table_name
modify
   (
   column1_name  column1_datatype,
   column2_name  column2_datatype,
   column3_name  column3_datatype,
   column4_name  column4_datatype
   );

The above command is really helpful and saves time while modifying multiple columns in Oracle.

For more tips and tricks on Oracle, click here.