select sid,username,machine,to_char(LOGON_TIME,'dd-mon-yyyy hh:mi:ss pm') from v$session order by username;
this will tell for all users .where username is null when the database is started
Why breaking the head for julian and all.
this will be easy the work.




Reply With Quote