Answer: With the help of Modify Column,we can change data-type of a column in Oracle database?
It's same as in MySql Database.
Syntax:-
Alter Table table_name
Modify Column column_name datatype.
For Example:-
Alter Table employee_master
Modify Column employee_code varchar(30);
Asked In: Many Interviews |
Alert Moderator