Answer 1

The "spool" command is used within SQL*Plus to direct the output of any query to a server-side flat file.

SQL> spool /tmp/myfile.lst

Becuse the spool command interfaces with the OS layer, the spool command is commonly used within Oracle shell scripts.