trigger w/ subquery

[pando]

select username from v$session where username = user;

but what if there are more than one user with same username login in? You will get two, three or even more rows

something would be like


create or replace trigger logon
begin
insert into logon values(user, sysdate);
commit;
end;/