var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sppoling output
I want to spool the output from the following query to a file
select * from v$tablespace;
But when I spool to a file, and I open I see the command and the file. is there anyway, I can just get the output without the command.
Your help is greatly appreciated
I seem to remeber its one of the SET xxx commands.
you need to use
SET TERMOUT ON
this ensures you see any output
To hide the commands that you type
SET ECHO OFF
make sure you use SPOOL OFF at the end
you may also want to use set hea off (ie set the header off-the column titles) and set pagesize 0 so it doesn't break the data up...