I use this: glogin.sql file found in $OH/sqlplus/admin on the db server. hth.
gene
--
-- $Header: /plus/v3/spam/precious/files/ACTIVE/glogin.sql,v 1.6 1995/07/25 02:33:26
cjones Exp $
-- Copyright (c) Oracle Corporation 1988, 1994, 1995. All Rights Reserved.
--
-- SQL*Plus Global Login startup file.
--
-- This is the global login file for SQL*Plus.
-- Add any sqlplus commands here that are to be
-- executed when a user invokes sqlplus
-- Used by Trusted Oracle
column ROWLABEL format A15
-- Used for the SHOW ERRORS command
column LINE/COL format A8
column ERROR format A65 WORD_WRAPPED
-- For backward compatibility
set pagesize 14
-- Defaults for SET AUTOTRACE EXPLAIN report
column id_plus_exp format 990 heading i
column parent_id_plus_exp format 990 heading p
column plan_plus_exp format a60
column object_node_plus_exp format a8
column other_tag_plus_exp format a29
column other_plus_exp format a44
-- Set SQLPLUS Prompt to Database Name
column instance_name noprint new_value dbname
column passout new_value dbname
set term off
-- Set default date format Y2K
alter session set nls_date_format="DD-MON-YYYY";
select instance_name, lower(instance_name) passout from gv$instance;
set term on
set sqlprompt '&&dbname>'
column name print
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).