I have a table log with these cols
This table gets populated by a trigger
CREATE OR REPLACE TRIGGER PV.UPDATE_GLOBAL_LOG
AFTER UPDATE OF LOGOUT_TIME
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
insert into global_users_log values(:new.pvid,:new.branding_id,:new.login_time,:new.logout_time);
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?
The insert statement in your after update trigger PV.UPDATE_GLOBAL_LOG does not contains the column TOTAL_TIME. I wonder how the insert st. is working ..... anyway just update the trigger to include the following insert statement :