Spooling Query output to an Existing File in SQL* Plus

 ** Email to info@shreyantech.com to get the Tip of the Day in your mailbox.

( Click here for a 1 min. Video of this topic )

 

In SQL* Plus, if the spool file already exists, SPOOL command will overwrite its contents by default. This is the same as using REPLACE option with SPOOL command.

SQL> SPOOL my_output.txt REPLACE

   To add new query output to the end of an existing file (without replacing the existing data), use APPEND option.

    SQL> SPOOL my_output.txt APPEND