| Re: How can i display the time consume in my processing [message #82017] |
Thu, 10 April 2003 08:17 |
JAFOD
Messages: 15
Registered: February 2003
|
Junior Member |
|
|
Try this version
DECLARE
v_elapsed date;
BEGIN
:global.start_time := TO_CHAR(SYSDATE,'RRRRMMDDHH24MISS');
-- message('your processing goes here...');
-- pause;
v_elapsed := trunc(SYSDATE) + (SYSDATE - TO_DATE(:global.start_time,'RRRRMMDDHH24MISS'));
message('Processing took: ' || to_char(v_elapsed,'HH24') || ' Hours, ' ||
to_char(v_elapsed,'MI') || ' Minutes, ' ||
to_char(v_elapsed,'SS') || ' Seconds.');
pause;
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
