>>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 (output-file-spec) -- specifies what file to write to
(stmts that produce output to screen) -- 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.
****************
last msg was messy. keep forgetting and use angle brackets.
**************
patrick