I a rookie, please the great god why look at me to write a trigger an error:
The create or replace the trigger tr_tguser_insert
Before the insert on the person
For each row

The begin

The SELECT p.p erson_id into dwcount from PERSON P where p.p erson_id=: new. Person_id;
If dwcount like '% a %' THEN

Insert into tabxx (person_id, person_name)
Values (: new person_id, : new person_name);
END IF;
The end;

And can trigger references view, such as the reference view whether the results of the query statement is inserted into the list

CodePudding user response:

Dwcount, this variable is not defined,

Ps: you can query the view,