`sqlplus -s userid/password@db<## WHENEVER SQLERROR EXIT FAILURE set pagesize 0 column XXX format a200 set feedback off set echo off set verify off set termout off set heading off set trimspool on set linesize 500 set long 32000 spool c:\\abc.txt select * from side_table / spool off set termout on