For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
CREATE OR REPLACE EDITIONABLE TRIGGER "BI_ITEM"
before insert on "ITEM"
for each row
begin
if :NEW."ITEM_ID" is null then
select "ITEM_SEQ".nextval into :NEW."ITEM_ID" from sys.dual;
end if;
end;