Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 29 October 2017

Modify Column in Oracle Table


Used to change the data type of existing column
Syntax:
          Alter table <table_name> modify <col  datatype>;
Example:
ALTER TABLE student MODIFY name VARCHAR2(50);
ALTER TABLE student MODIFY (name VARCHAR2(100), email VARCHAR2(100));
Note: To reduce the data type size, it will support only on empty table
Share this article :

0 comments:

Post a Comment