| How can i display the time consume in my processing [message #81989] |
Tue, 08 April 2003 01:39  |
Susane
Messages: 27
Registered: September 2002
|
Junior Member |
|
|
Hi! to all
Please help me how can i display the time consumed
during my processing. I wanted to monitor the time because user wanted to monitor how much time consumed including the hours, minutes and seconds. I run my processing programs thru forms.
Thanks and i will highly appreciate your time in helping me..
|
|
|
|
| Re: How can i display the time consume in my processing [message #81991 is a reply to message #81989] |
Tue, 08 April 2003 06:12  |
JAFOD
Messages: 15
Registered: February 2003
|
Junior Member |
|
|
Assuming your process is called from a trigger, you can do something like this in your trigger code:
DECLARE
v_start date;
v_elapsed date;
BEGIN
v_start := SYSDATE;
YOUR_PROCESSING;
v_elapsed := trunc(SYSDATE) + (SYSDATE - v_start);
message('processing took: ' || to_char(v_elapsed,'HH:MI:SS') || ' seconds');
pause;
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
