Plsql program for updating

10-Oct-2017 06:51

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.

plsql program for updating-25

dating site that requires credit cards

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.