Gavin, We have a similar situation. We simply maintain two tables - one to maintain login-history and another to record the latest-login. The latest-login table would be updated by a trigger on the history-table.
A procedure checks both tables and returns approppriate info. -Madhu >From: "Gavin D'Mello" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Get the Latest Date >Date: Fri, 12 Apr 2002 02:43:25 -0800 > >Hi, > I have read up quite a lot before posting this message so please >bear with me if this question is trivial. > I have table which stores session information of users. I have to develop >a >report which gives me the number of times users have logged in ( which is >straightforward ) as well as their last access time. > Since every user has multiple records in the table, I was trying >to >find a way to get me just one row per user which returns the latest date, >rather than checking for the latest date in the client logic. > Is there any function in Oracle which would return the latest date >? > >Thank You, > >Gavin > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gavin D'Mello > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhusudhanan Sampath INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
