/* @C:\WIN_V4\SQL\BEGIN_CONV\ORACLE\0001_PEDTMP_ATUALIZA_RAMOATIV.SQL */
ALTER TABLE ATIVCLIENTE
ADD CDARVATIVCLI VARCHAR2(20)
/
ALTER TABLE ATIVCLIENTE
ADD CDNVATIVCLI VARCHAR2(1)
/
ALTER TABLE PARAMGERAL
ADD CDPICTATIVCL VARCHAR2(20)
/
UPDATE ATIVCLIENTE
SET CDARVATIVCLI = CDATIVCLI,
    CDNVATIVCLI  = '1'
WHERE CDARVATIVCLI IS NULL
/
UPDATE PARAMGERAL
SET CDPICTATIVCL = '99999'
WHERE CDPICTATIVCL IS NULL
/
COMMIT
/
