Setting Up Login.SQL

REM
REM File:    Login.sql
REM Purpose: SQL*Plus login script.
REM


REM
REM Set the session's prompt to be something like:
REM username@global_name>
REM
SET TERMOUT OFF

COLUMN gname NEW_VALUE gname
SELECT
  LOWER(USER)
  || '@'
  || LOWER(global_name) AS gname
FROM global_name;
SET SQLPROMPT '&gname> '



REM
REM Other settings.
REM
SET TERMOUT ON
SET PAGESIZE 30
SET LINESIZE 132
SET LONG 132
SET TRIMSPOOL ON
REM SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
SET FEEDBACK ON
SET PAUSE ON PAUSE More...
SET SERVEROUTPUT ON SIZE 32000
SET EDITFILE "afiedt.buf"
DEFINE _editor=vi

REM
REM Set the date/time format to something a little more useful than the default.
REM
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';

REM
REM Various column formatting settings.
REM
COLUMN object_name   FORMAT A30
COLUMN object_type   FORMAT A30
COLUMN plan_plus_exp FORMAT A80

CLEAR SQL

REM
REM Ends.
REM