Recommended global Global.sql

This recommended global setting when we use SQL*PLUS Editor

Local

-- NAME

--   glogin.sql

--

-- DESCRIPTION

--   SQL*Plus global login "site profile" file

--

--   Add any SQL*Plus commands here that are to be executed when a

--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.

--

-- USAGE

--   This script is automatically run

--

set sqlprompt "_user'@'_connect_identifier> "

set feed on head on

set serveroutput on

col username for a20

col tablespace_name for a30

set pages 50000

set numformat 9999999999999999

column object_name format a30

column segment_name format a30

column file_name format a40

column name format a30

column file_name format a30

column what format a30 word_wrapped

col tbalespace_name for a15

col file_name for a45

col table_name for a30

col username for a15

col owner for a20

col COLUMN_NAME for a30 word_wrapped

col VALUE for 99999999999999999999

set term off

alter session set nls_date_format='dd-MON-yyyy hh:mi:ss am';

alter session  set db_file_multiblock_read_count =128;

set term on

-- set numwidth