Plsql program for updating
The actual parameter must be variable and it is passed by value.
IN OUT An IN OUT parameter passes an initial value to a subprogram and returns an updated value to the caller.
4)If you ROLLBACK the transaction before committing to the database, the data inserted to the table is also rolled back.
There are two types of triggers based on the which level it is triggered.
The actual parameter corresponding to an IN OUT formal parameter must be a variable, not a constant or an expression. So, a is substituted for x, b is substituted for y, c is substituted for z and d is substituted for m.
This events will alternates between BEFORE and AFTER row level triggers.