create table usuper(
       EMPRES_CODIGO VARCHAR(4)
     , FILIAL_CODIGO VARCHAR(4)
     , USUPER_SEQ INTEGER
     , USUPER_CODIGO VARCHAR(20)
     , USUPER_DESCRICAO VARCHAR(50)
     , USUPER_STATUS INTEGER
     , SETOR_STRING varchar(1000)
     , TAREFA_STRING varchar(1000)
     , PRIMARY KEY(USUPER_SEQ)
)

--Abaixo para Oracle
CREATE SEQUENCE SEQ_USUPER
    INCREMENT BY 1
    START WITH 0
;

CREATE TRIGGER TG_BI_USUPER
BEFORE INSERT
    ON usuper
    FOR EACH ROW
DECLARE

BEGIN
   SELECT SEQ_USUPER.NEXTVAL
   INTO :NEW.USUPER_SEQ FROM dual;
EXCEPTION
    WHEN OTHERS THEN ROLLBACK;
END;
;
