create or replace trigger idcarinserter before insert on cars for each row declare loggeduser varchar2(15); begin select user into loggeduser from dual; :new.EnteredBy := loggeduser; end; /