- create or replace trigger TRG_INTERFACE_CRM_CONVERT_ID
- before insert on interface_crm
- for each row
- declare
- -- local variables here
- begin
- select SEQ_INTERFACE_CRM_CONVERT_ID.nextval
- into :new.convert_id
- from dual;
- select sysdate
- into :new.arrive_date
- from dual;
- end TRG_INTERFACE_CRM_CONVERT_ID;
- /