Guys
I have a table log with these cols
pvid,barnd,login_time,logout_time,total_time.
This table gets populated by a trigger
CREATE OR REPLACE TRIGGER PV.UPDATE_GLOBAL_LOG
AFTER UPDATE OF LOGOUT_TIME
ON PV.GLOBAL_USERS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
begin
insert into global_users_log values(:new.pvid,:new.branding_id,:new.login_time,:new.logout_time);
end;

This trigger doesnt populates Total_time column in table.This being newcolumn we want this to be populated thro same trigger only and the value should be logout_time-login_time.
Can we do this and request u guys let me know how to do?
Thanks folks