writing records while doing select.

Question posted by: Eitan M (Guest) on June 27th, 2008 07:03 PM

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 :)

Not the answer you were looking for? Post your question . . .
190,076 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).