create or replace trigger jinxintest
before update or insert on jinxin_test
for each row
declare
-- local variables here
begin
select to_number(:new.yn_short)-to_number(:new.real) into :new.yn_short_diff from dual;
end jinxintest;
before update or insert on jinxin_test
for each row
declare
-- local variables here
begin
select to_number(:new.yn_short)-to_number(:new.real) into :new.yn_short_diff from dual;
end jinxintest;