create table my_log (as_of date,
                 username varchar2(128),
                 account_status varchar2(32),
                 lock_date date);

insert into my_log (select sysdate,
          a.username, a.account_status, a.lock_date from dba_users a);