Our oracle db has various users with same schema. I would like to add a column to one table in those schemas. The same column to same table in every schema. I know that I can do that manually, like that
alter table user1.EMER_COMP add TELEFONE varchar2(20) NULL;
alter table user2.EMER_COMP add TELEFONE varchar2(20) NULL;
Is there an easier way to do this?