To add a column without using create, you can use the ALTER TABLE statement.

• Use the ALTER TABLE statement to add a new column to an existing table

• Specify the table name and the new column name, data t...read more

alter table emp add sal number(7,2);

alter table emp add column 'joining_date'

Alter table table-name add column-name datatypes

Alter Table Table_name Add Column Column_name (Datatype Size)