[DB] [Oracle] trigger to create an instance

[DB] [Oracle] trigger to create an instance

// Trigger name usertotemp

Create or replace trigger usertotemp after insert or update or delete

On user_info for each row // triggers the following events when operating on the table user_info

Declare // declare a variable

Integrity_error exception;

Errno integer;

Errmsg char (200 );

Dummy integer;

Found Boolean;

Sexy varchar2 (20 );

Begin

If inserting then

Select sex into sexy from user_info_test; // obtain the value of the sex field in the user_info_test table and assign it to the variable sexy.

Insert into user_info_temp (ID, username, password, createdate, status) values (: New. ID,: New. username, sexy,: New. createdate,: New. status); //: New. the username value is the newly added data in table user_info.

Elsif updating then

Update user_info_temp Set ID =: New. ID, username =: New. username, password =: New. Password, status =: New. status where id =: Old. ID;

Elsif deleting then

Delete from user_info_temp where id =: Old. ID;

End if;

Exception

When integrity_error then

Raise_application_error (errno, errmsg );

End;