CREATE OR REPLACE TRIGGER input_mileages_after_insert AFTER

INSERT ON emora.wm_point

FOR EACH ROW

DECLARE

t_no NUMBER;

BEGIN

SELECT MAX(no)+1

INTO t_no

FROM mileages;

INSERT INTO mileages

(no, mem_id, code, mileage, reg_date, last_date, conn_key, status, ip, description )

VALUES (

t_no,

:new.customerid,

'4',

:new.point,

:new.in_date,

:new.in_date,

:new.metasessionid,

'R',

'trigger',

:new.description);

END;

/