SQL Logging Syntax

SPOOL ;
WHENEVER SQLERROR EXIT SQL.SQLCODE
SET ECHO ON;
SET TIME ON;

-- SQL Or PL/SQL

SPOOL OFF;


SPOOL ;
WHENEVER SQLERROR CONTINUE;
SET ECHO ON;
SET TIME ON;

-- SQL Or PL/SQL

SPOOL OFF;