ALTER TABLE PARAMGERAL ADD NRMINFOSEXT NUMBER
/
BEGIN
   DECLARE V_COUNT NUMBER;
   BEGIN
      SELECT COUNT(*) INTO V_COUNT FROM PARAMGERAL WHERE NRMINFOSEXT IS NULL;
      IF V_COUNT > 0 THEN
         UPDATE PARAMGERAL SET NRMINFOSEXT = 10;
         COMMIT;
      END IF;
   END;
END;