ALTER TABLE TIPOOPERAC ADD IDBLOQPRESTTPOP VARCHAR2(01) DEFAULT 'N'
/

UPDATE TIPOOPERAC
SET IDBLOQPRESTTPOP = (SELECT NVL(MAX(IDBLOQPRESTO), 'N')
FROM PARAMESTOQUE)
WHERE CDTIPOOPER = '01'
AND IDENTRSAIDOP = 'E'
/

COMMIT
/ 