CREATE OR REPLACE PROCEDURE pruebaborrar as
begin
execute immediate 'drop table vistaempleadosemt';
execute immediate 'create table vistaempleadosemt as select * from noticiasw';
end;
/