SQL> spool c:\ocp_project\last_record.txt
SQL> INSERT INTO ABC VALUES ('A');
1 record inserted


SQL> UPDATE ABC SET TYPE='B';

updated

SQL> spool off;

check the file in the specified dir.