Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to fix the timing format in SQL*Plus, 8i?

Re: How to fix the timing format in SQL*Plus, 8i?

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Sun, 11 Aug 2002 15:29:13 +0100
Message-ID: <3D5674B9.32F95FF0@exesolutions.com>


Unemployed in the Valley wrote:

> How do I get rid of that:
>
> set timimg on
> exec myproc;
>
> PL/SQL procedure successfully completed.
>
> Elapsed: 01:111:6690.60
> ========
>
> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> I would rather prefer 01:51:18, the way it used to be before 8i.
> Is there a method to format this?

Wouldn't we all.

Daniel Morgan Received on Sun Aug 11 2002 - 09:29:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US