CREATE OR REPLACE TRIGGER simo_tab_insert
INSTEAD OF INSERT ON v_simo_tab
BEGIN
declare
v_id number;
begin
select count(*) into v_id from simo_tab where name = :new.name;
dbms_output.put_line('Simo>>>>>>>>v_id:' ------解决方案-------------------- v_id);
if v_id>0 then
insert into simo_tab(id, name)
values (:NEW.id,:new.name);
end if;
end;
END;