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; |