Re: SET TIMING ON

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 20 Jun 1999 21:31:53 +0800
Message-ID: <376CED49.7166@yahoo.com>

Tim Rooney wrote:
>
> When you set timing on in the NT/WIN 95 version of SQL*PLUS you get the
> results in milliseconds. Is there a way to change this to elapsed time.
> (HH:MI:SS)
>
> Any help would be appreciated.
>
> Thank You,
>
> Tim Rooney
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----

Not that I know...Some alternatives...

A> set time on
(shows time as the prompt - you have to do the math yourself)

B> define a variable,

   stick sysdate into it
   run you query
   do a select sysdate-variable from dual after it

HTH --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jun 20 1999 - 08:31:53 CDT