SQL - DML para renomear operações cujos nomes globais tenham sido alterados

RTSYSINF.FAQ-8098

Exemplo para renomear todo um sub-istema:

update operacoes_sistemas
set operacao = 'SISTEMA_NOVO' || substr(operacao,position('.' in operacao))
where operacao like 'SISTEMA_VELHO.%' ;

Fazer um preview:

select operacao, 'SISTEMA_NOVO' || substr(operacao,position('.' in operacao))
from operacoes_sistemas
where operacao like 'SISTEMA_VELHO.%' ;

Exemplo para renomear apenas um grupo de interfaces:

update operacoes_sistemas
set operacao = 'ADS_CORE'||substr(operacao,position('.' in operacao))
where operacao like 'ADS.CAD_ATRI.%'
or operacao like 'ADS.CAD_BLOCK_REL.%'
or operacao like 'ADS.CAD_CAMP.%'
or operacao like 'ADS.CAD_DOM.%'
or operacao like 'ADS.CAD_ENT.%'
or operacao like 'ADS.CAD_INT.%'
or operacao like 'ADS.CAD_METH.%'
or operacao like 'ADS.CAD_REET.%'
or operacao like 'ADS.CAD_USAG.%'
;

Preview:

select operacao,'ADS_CORE'||substr(operacao,position('.' in operacao))
from operacoes_sistemas
where operacao like 'ADS.CAD_ATRI.%'
or operacao like 'ADS.CAD_BLOCK_REL.%'
or operacao like 'ADS.CAD_CAMP.%'
or operacao like 'ADS.CAD_DOM.%'
or operacao like 'ADS.CAD_ENT.%'
or operacao like 'ADS.CAD_INT.%'
or operacao like 'ADS.CAD_METH.%'
or operacao like 'ADS.CAD_REET.%'
or operacao like 'ADS.CAD_USAG.%'
;