create or replace trigger “T_HLO_ENT_TP_LOOKUP” before insert or update on “HLO_ENT_TP_LOOKUP” for each row begin if inserting and :new.”HLO_ENT_TP_ID” is null then
for c1 in (select “HLO_ENT_TP_LOOKUP_SEQ”.nextval nv from dual) loop
:new.”HLO_ENT_TP_ID” := c1.nv;   end loop; end if; end;

 

create or replace TRIGGER  “HC_DATABASE_TRIG”
BEFORE INSERT ON MRCULP.HC_DATABASE FOR EACH ROW
BEGIN
SELECT hc_database_seq.NEXTVAL
INTO   :new.db_id
FROM   dual;
END;

 

CREATE SEQUENCE   “HLO_ENT_SEQ”  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 5 NOCACHE  NOORDER  NOCYCLE  NOPARTITION
/