SQL> spool test.log
SQL> < ... do your stuff ... >
SQL> spool off

set pause on
select * from cat;

Q:    How to use "set pause" in SQL*Plus ?                                      
                                                                                
A:    For example to get 'Underlined prompt' in a VT220
      terminal use the following code in your login.sql:
      set pause <ESC>[1m<ESC>[4m'Underline prompt'<ESC>[m
      set pause on

      Note that the <ESC> must be a real esc, not the characters <,E,S,C and >.