Alters on a Table

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. Adding a column in an existing table Syntax : ALTER TABLE table_name ADD column_name datatype; Example : ALTER TABLE employee ADD emp_age number; Deleting a column from an existing table Syntax : ALTER TABLE table_name DROP COLUMN column_name; Example…

Details