How to create a last_modified field in oracle 9i?
===

I'm using Oracle 10g Express or Oracle XE. In the EMPLOYEES table I want to add another column call last_modified that automatically generate current date or date/time if it has been modified. I know there is this rowscn(timestamp) thing that's only available from oracle 10g onwards but I want to manually create one because my client is using oracle 9i but I only have 10g to do the testing. Also I've never use oracle before. This is for some integration project with Lotus Notes. Therefore if possible I want the date or date/time to recognizable by LotusScript.