REM ------------------------------------------------------------------------------------------------

REM $Id: plusenv.sql,v 1.4 2003/03/26 18:04:47 dixi Exp $

REM Author : dixi

REM #DESC : Set default sqlplus environment

REM Usage : run automatically at sqlplus logon

REM Description: called by login.sql

REM ------------------------------------------------------------------------------------------------

set autocommit off

set echo off

set feed on

set head on

set lines 250

set long 10000

set pages 1000

set serveroutput on size 1000000

set trimspool on

set verify off

set pause off

ttitle off

clear breaks

clear columns

col blksz new_value blocksz

set termout off

select value blksz

from v$parameter

where name = 'db_block_size'

;

alter session set nls_date_format = 'YYYY/MM/DD HH24:MI:SS';

set termout on