To add, delete, or modify columns in an existing table. The ALTER TABLE statement is used.
To add a column in a table, the syntax is
ALTER TABLE table_name
ADD column_name column-datatype;
ALTER TABLE table_name
ADD (column_1 column-datatype,
column_2 column-datatype,
...
column_n column_datatype);
ALTER TABLE students
ADD (student_type varchar2(40),
student_address varchar2(40));
ALTER TABLE table_name
MODIFY column_name column_type;
ALTER TABLE students
MODIFY student_name varchar(200) not null;
ALTER TABLE table_name
MODIFY (column_1 column_type,
column_2 column_type,
...
column_n column_type);
ALTER TABLE students
MODIFY (student_name varchar(200) not null,
class varchar(200));
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
ALTER TABLE students
RENAME COLUMN student_name to lname;