ALTER

DROP Table Statement in Oracle

DROP statement is used to do below operations:

• DROP ONE OR MORE EXISTING COLUMNS
• DROP AN EXISTING TABLE

DROP ONE OR MORE EXISTING COLUMNS:

We have an existing table called EMP_ALTER_TAB with below definition:

…

ALTER Table Statement in Oracle

ALTER statement is used to do below operations:

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

…