Auto-growth of non-primary keys in Oracle

Create sequence JCDA_GFYYXX_IDminvalue 1 maxvalue 99999999 start with 21 increment by 1 cache 20; create or replace trigger into before insert on JCDA_GFYYXX_TB -- JCDA_GFYYXX_TB is the table name for each rowdeclare -- local variables here nextid number; -- custom variable, used to store values obtained from the sequence begin IF: new. objectid is null or: new. OBJECTID = 0 THEN select JCDA_GFYYXX_ID.NEXTVAL -- Obtain the next value from the sequence and assign it to the variable nextid into nextid from DUAL;: new. OBJECTID: = nextid; end if; end TRG_MAGGIE_TEST_TID;