text: 
    CREATE OR REPLACE TRIGGER "CF_TEMP_BARCODE_PARTS_KEY" 
   before insert  ON cf_temp_barcode_parts
   for each row
      begin
      	if :NEW.key is null then
      		select somerandomsequence.nextval into :new.key from dual;
      	end if;
      end;
  
  ALTER TRIGGER "CF_TEMP_BARCODE_PARTS_KEY" ENABLE