DDL na PL/SQL

[Rômulo Silva 0]

Pessoal é o seguinte como eu faço para executar o script abaixo dentro da SQL

 

drop table TEMP_DROP_FK;
  create global temporary table TEMP_DROP_FK(texto varchar2(1000));

  insert into TEMP_DROP_FK  
  select
	'ALTER TABLE ' || table_name || ' DROP CONSTRAINT ' || constraint_name || ';'
  from
	ALL_CONSTRAINTS
  where
	--owner='APG'
	owner='PROSPERNET' and
	(table_name like 'GER_%' 
	OR table_name like 'AMACAO_DISTRIBUICAOS18G0812272'
	OR table_name like 'CAD_EMPRESAS18G0812250'
	OR table_name like 'ER_COLUNA_GERENCIALS18G0812253'
	OR table_name like 'ER_FILTRO_GERENCIALS18G0812240'
	OR table_name like 'ER_FONTE_LANCAMENTOS18G0812257'
	OR table_name like 'ESULTADO_PROGRAMADOS18G0812268'
	OR table_name like 'FIGURACAO_GERENCIALS18G0812237'
	OR table_name like 'GER_AREAS18G0812234'
	OR table_name like 'GER_CALCULO_FUNDINGS18G0812251'
	OR table_name like 'GER_CAMBIOS18G0812252'
	OR table_name like 'GER_CARTEIRAS18G0812235'
	OR table_name like 'GER_CLASSIFICADORS18G0812236'
	OR table_name like 'GER_CONTA_CONTABILS18G0812262'
	OR table_name like 'GER_COTACAOS18G0812255'
	OR table_name like 'GER_DISTRIBUICAOS18G0812256'
	OR table_name like 'GER_ERRO_APURACAOS18G0812270'
	OR table_name like 'GER_FERIADOS18G0812239'
	OR table_name like 'GER_FUNDINGS18G0812271'
	OR table_name like 'GER_INDEXADORS18G0812241'
	OR table_name like 'GER_LANCAMENTOS18G0812263'
	OR table_name like 'GER_PERIODOS18G0812242'
	OR table_name like 'GER_PRACA_FERIADOS18G0812244'
	OR table_name like 'GER_PRACAS18G0812243'
	OR table_name like 'GER_RELACAO_DE_PARAS18G0812258'
	OR table_name like 'GER_RESULTADOS18G0812265'
	OR table_name like 'GER_SISTEMA_LEGADOS18G0812245'
	OR table_name like 'GER_TAXAS18G0812246'
	OR table_name like 'GER_TIPO_OPERACAOS18G0812259'
	OR table_name like 'GER_TITULARS18G0812247'
	OR table_name like 'GER_TRADERS18G0812248'
	OR table_name like 'GER_VALOR_DE_PARAS18G0812261'
	OR table_name like 'OGRAMACAO_RESULTADOS18G0812264'
	OR table_name like 'PO_OPERACAO_DE_PARAS18G0812260'
	OR table_name like 'R_CONTROLE_APURACAOS18G0812254'
	OR table_name like 'R_RESULTADO_ESTORNOS18G0812266'
	OR table_name like 'R_USUARIO_GERENCIALS18G0812249'
	OR table_name like 'RESULTADO_IMPORTADOS18G0812267'
	OR table_name like 'RIBUICAO_LANCAMENTOS18G0812269'
		OR table_name like 'SOLIDACAO_GERENCIALS18G0812238'
		OR table_name like 'CAD_EMPRESA'
		)
		
	and constraint_type='R'
  order by
	table_name;

Este código gera um texto DDL (Alter table com todas as foreign key oara que sejam deletadas);

Porém ele me retorna muitas linhas, como eu faço para executar todas as linhas de uma só vez.

[Motta 645]

Veja se ajuda

 

http://forum.imasters.com.br/index.php?showtopic=266276