Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL
PL/SQL [message #348319] Tue, 16 September 2008 07:22 Go to next message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
Hi

I am executing a select statement but with that select statement i want that it should also give the time taken by the statement for execution?

i m using sql plus
can anybody tell me how can i do that
Re: PL/SQL [message #348323 is a reply to message #348319] Tue, 16 September 2008 07:32 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
set timing on
Re: PL/SQL [message #348326 is a reply to message #348319] Tue, 16 September 2008 07:38 Go to previous message
monikabhakuni
Messages: 110
Registered: September 2008
Location: India
Senior Member
Thanks Smile
Previous Topic: array basics
Next Topic: union query not returning expected result
Goto Forum:
  


Current Time: Thu Dec 08 18:29:29 CST 2016

Total time taken to generate the page: 0.08014 seconds