Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: how to create a trigger on attendance table

    create or replace trigger atten_emp

    after delete or insert update on attendance_table

    for each row

    begin

    update into atten_emp(emp_id,emp_name,login_time,logout_time,login2_time,logout2_time)

    values(user,sysdate,:emp_id,:emp_name,:login_time,logout_time:=1pm,login2_time,logout2_time);

    end;

    /

Viewing post 1 (of 2 total)