Home » Developer & Programmer » Forms » Re: How can i display the time consume in my processing
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;
Previous Topic: Excel sheet read from Forms
Next Topic: Reading cell value...
Goto Forum:
  


Current Time: Thu Mar 28 05:01:27 CDT 2024