How To Create Log file for Oracle SQL

You need to write

SPOOL <Log File Name>.log at the beginning of SQL file.

SPOOL OFF at the end of the SQL file.

it will create log file in the same directory from where you are executing SQL.