MODIFY

MODIFY Table Statement in Oracle

MODIFY statement is used to do below operations:

• MODIFY ONE OR MORE EXISTING COLUMNS
• SET A DEFAULT VALUE FOR A COLUMN
• REMOVE A DEFAULT VALUE FOR A COLUMN

We have a table called EMP_ALTER_TAB with …