Add column to a table for every shema in an oracle db 11g
begin
  for t in (select * from dba_tables where table_name = 'EMER_COMP')
  loop
    execute immediate 'alter table "' || t.owner || '"."' || t.table_name || '" add TELEFONE varchar2(20) NULL'; 
  end loop;
end;
/