CREATE SEQUENCE   "ARE_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE
/


CREATE OR REPLACE TRIGGER  "ARE_TRG1"
              before INSERT ON areas_atuacoes
              FOR each ROW
              BEGIN
                  IF :NEW.id_area IS NULL THEN
                      SELECT are_seq.NEXTVAL INTO :NEW.id_area FROM sys.dual;
                  END IF;
              END;
/
ALTER TRIGGER  "ARE_TRG1" ENABLE
/