alter table, add column – Oracle Example Syntax

Following is simple example syntax for adding a column to an Oracle table using “alter table” SQL:

1
2
ALTER TABLE [my_table_name]
ADD [my_column_name] [my_data_type];

A simple example would be:

1
2
ALTER TABLE employee
ADD tps_reports_completed NUMBER;

Leave a Reply

Your email address will not be published. Required fields are marked *