Skip to Main Content

SQL Developer

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 Developer - Suppress query output

User_SXCT5Aug 31 2021 — edited Aug 31 2021

Hi,
I am trying to suppress the query output in SQL Developer. The query returns close to 50,000 records and the goal is to gauge the query run time. I have seen different approaches like wrap the query inside select count(*) block etc but they do not seem to provide even somewhat realistic runtime in my case.
So, I am having to resort to SQL Developer's built in display time for a script execution task. As the output volume is huge, rendering it affects the display time and hence the need to turn off the output altogether.
SQL Developer version: 20.4.1.407

Comments
Post Details
Added on Aug 31 2021
4 comments
1,510 views