What is difference between alter and modify on oracle?
MODIFY is a clause used within an ALTER statement, such as ALTER
TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY
isn't a command by itself.
For example, you might change the length of a text column in a
table with the following:
ALTER TABLE employee MODIFY (email_address VARCHAR(132));