alter table, add column – Oracle Example Syntax

AshokTechnical TipsLeave a Comment

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.