Hi, i need to extract information from an Oracle 9i database about any user that has been logged onto the database for more than a month... any suggestion.
select * from v$session where (sysdate - logon_time) > 30
Originally posted by craigkel
Hi, i need to extract information from an Oracle 9i database about any user that has been logged onto the database for more than a month... any suggestion.
Comment