Create the trigger preson_insert_beffor
Before the insert on preson
For each row
Declare
The begin
Select the 'p' | | trim (to_char (preson_pid nextval, '999')) into pname:=: new. The pname and psex:=: new. Psex and dar:=: new. Dar and age:=: new. The age from dual;
end;

CodePudding user response:

Select the 'p' | | trim (to_char (preson_pid nextval, '999')) into pname:=: new. The pname and psex:=: new. Psex and dar:=: new. Dar and age:=: new. The age from dual;
This is what the hell, what do you want to do, want to achieve

CodePudding user response:

Pname is this variable? Can't be used variables need to be defined, not great variable:=this form

Into can also give the variable assignment, but in front of you into should only one value, can only be assigned to a variable

Other anyway this statement completely look not to understand

CodePudding user response:

Say your intention, what will you do look not to come out from this statement,