Oracle Alter Statement

To add, delete, or modify columns in an existing table. The ALTER TABLE statement is used.

Oracle ALTER TABLE Syntax

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;

❮ Previous Next ❯