The content of the code: create a trigger
The create or replace the trigger auid
Before
Insert on
The person
For each row
Declare

The begin
Select s_person. Nextval into: new pid from dual;
end;
Create a table: the create sequence s_person;

The create table person (
The pid number (25),
Pname varchar2 (10)
);
Operation:
Insert into person values (1, 'a');
commit;

CodePudding user response:

An error has been ineffective and ORACLE triggers failed to verify

CodePudding user response:

The trigger cell is not red fork amount