gologin.sql
Here's an example from Oracle:
--
-- $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
"Farnsworth,
Dave" To: Multiple recipients of list ORACLE-L
<DFarnsworth <[EMAIL PROTECTED]>
@Ashleyfurnit cc:
ure.com> Subject: Customize my SQLPlus login
Sent by: root
03/26/2002
08:38 AM
Please
respond to
ORACLE-L
What is the file that I need to edit on my client PC to set personalized
settings for SQLPlus so that I do not have to set these at the command
prompt every time I start a new session?
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
