scott schema

/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlsampl.sql

alter table table_name add id number;

alter table table_name drop column id;