writing records while doing select.

[Eitan M]

Hello,
I am creating a report via select statement.
I have Oracle 9i.
What I want is to keep the running time of the select statement somewhere in
the database.
(It should be timestamp, not date type).
I want to update database records, while I am running the sql statement,
to keep the last running time of sql statement.

How can I do that ?

I would be glade to have a sample code, please (creating table / package +
select statement).

Thanks :)