Add column to a table for every shema in an oracle db 11g

by Vitor Mira   Last Updated May 24, 2018 16:06 PM

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?

Related Questions

Altering the location of Oracle-Suggested Backup

Updated July 03, 2016 08:02 AM

Ways to Schedule Rman backups

Updated February 24, 2017 12:06 PM

EMCA insists that it cannot connect to the service

Updated August 28, 2017 14:06 PM

Password for Oracle Database 18c user “system”

Updated August 02, 2018 06:06 AM