ALTER TABLE PARAMIMPOSGUIA ADD VRENCARGO VARCHAR2(1)
/

ALTER TABLE PARAMIMPOSGUIA ADD CDENCARGO VARCHAR2(2)
/

ALTER TABLE PARAMIMPOSGUIA ADD PRDIGMANVR VARCHAR2(1)
/

ALTER TABLE PARAMIMPOSGUIA ADD CDTIPOOPER VARCHAR2(100)
/

INSERT INTO LEIAUTEREFDIRF
   (CDANOREF, IDESTRUTURA)
   (SELECT '2024', 'B3VH8RQ' 
      FROM DUAL
     WHERE NOT EXISTS (SELECT * FROM LEIAUTEREFDIRF WHERE CDANOREF = '2024'))
/
COMMIT
/