oracle - Check updated value in orale -

oracle - Check updated value in orale -

i trying write oracle trigger find updated value form particular column of table. need value, check value , variable table. example.

let's there table of employee attendance, has attendance , employee, when updating attendance, need updated value (is equal 1) corresponding employee? (to porcess)

try approach. in case of mass updates (e.g updating multiply rows) seek the returning mass collect into clause.

declare lv_value varchar2(4000); li_empid employee.id%type; begin -- updateing attendance table. update attendance set value = 1 <some_expression_defining_the_row_for_update> -- returning updated value , correspoinding employee id returning value, empid lv_value, li_empid; -- doing process do_another_porcess(lv_value, li_empid); end;

hope helps you.

oracle oracle11g