>While using the SQL*Plus tool to query data I saw on the Menu the following options : File--->Spool---->SpoolFile.../Spool off.
>Does anyone knows the purpose of this items.??
>It looks like they are used to send data to a file. But I am not clear on the Purpose/functionality of Spool off.
>
>Sergio O.
those menu commands are equivalent to the pl/sql sequence
spool
-- specifies what file to write to
-- output is directed to file
spool out -- stops output to file
as other mentioned, you can also include column formatting
commands. another useful functionality you may want to investigate
is the trim-trailing-spaces command. trim-spool or something like that.
patrick