how to suppress output from a SELECT in the Script Output page
973026Nov 7 2012 — edited Nov 8 2012Hi there,
I'm running a particular piece of SQL with some bind variables. The aim is to get the execution
plan using DBMX_XPLAN.DISPLAY_CURSOR.
To get the variables and bind variable values in them to work, I've found that I have to select
the statements in the Worksheet, and then hit F5.
That all works fine, but the issue i have is that this particular SQL returns over 60,000 rows.
I don't want to see the rows, and furthermore there are limits on how many rows can be displayed
in SQL developer.
Is there a way I can suppress the results of the SQL query appearing in the Script Output window?
I've tried :
set termout off
set autotrace traceonly
set pagesize 0
But nothing makes any difference. Surely I can stop it from behaving in this way? Any suggestions?
I am using SQL Developer 3.2.09
thanks!
Paul Stuart