SPOOL EXP file

SET ECHO OFF;
SET HEADING OFF;
SET FEEDBACK OFF;
SET VERIFY OFF;
SET NEWPAGE NONE;
SET TERM OFF;
SET FEED OFF;
SET LINESIZE 10000;
--writes trailing spaces when spooling data to a file. The default setting is OFF, which causes SQL*Plus to write each line to the spool file in its entirety, trailing spaces and all.
SET TRIMSPOOL ON;
--displays any trailing spaces that may occur at the end of a line. The default setting is ON, which causes SQL*Plus to display only up to the last nonblank character on a line.
SET TRIMOUT ON;
SET WRAP OFF;
--Turns output to the terminal on or off.
SET TERMOUT OFF;
--add below for speed up
SET ROWPREFETCH 2;
--add below for speed up
SET ARRAYSIZE 100;
SET SERVEROUTPUT ON FORMAT WRAPPED;
DEFINE c_delimiter='￥';
@'$SCRIPT_SQL/$TBL_NAME.sql'