Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Plus do not display output but get query run time

vijzMay 15 2018 — edited May 16 2018

We have a SQL query which outputs huge amount of data.  Our DB is Oracle 11g V2. We are running query on SQL Plus.

We don't want to print the data, but just would like to print query execution time on the screen

In SQL query file, can we write like below:

set timing on 
< Select Query >
set timing off

what is the best approach?
This post has been answered by Paulzip on May 15 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2018
Added on May 15 2018
15 comments
12,263 views