52 lines
963 B
SQL
52 lines
963 B
SQL
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : This script is called at end of every other script
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 05-Aug-04 Vishal Gupta Created
|
|
*
|
|
*/
|
|
|
|
|
|
-- VG_SPOOLFILE is being set in the login.sql
|
|
-- spool again to flush the buffer contents to file
|
|
--spool &&VG_SPOOLFILE append
|
|
|
|
CLEAR COLUMNS
|
|
CLEAR BREAKS
|
|
CLEAR COMPUTES
|
|
|
|
set trimspool on
|
|
set feed on
|
|
set arraysize 5000
|
|
set lines 80
|
|
set pages 80
|
|
set verify on
|
|
set sqlblankline on
|
|
set serveroutput on
|
|
set tab off
|
|
set term on
|
|
--start backupenv
|
|
|
|
DEFINE 1=""
|
|
DEFINE 2=""
|
|
DEFINE 3=""
|
|
DEFINE 4=""
|
|
DEFINE 5=""
|
|
DEFINE 6=""
|
|
DEFINE 7=""
|
|
DEFINE 8=""
|
|
DEFINE 9=""
|
|
DEFINE 10=""
|
|
|
|
-- VG_SPOOLFILE is being set in the login.sql
|
|
-- spool again to flush the buffer contents to file
|
|
-- spool &&VG_SPOOLFILE append
|
|
|
|
--set echo on
|
|
PROMPT |