Create yourself a script called "connect.sql" that looks like:
connect &1
@@glogin.sql
Keep it in your SQL_PATH just like your glogin.sql. Now when you connect
to something else just precede your "connect" statement with a "@" as in:
@connect un/pw@db02
Can't be much easier than that.
Brian P. MacLean
Oracle DBA, OCP8i
"Boivin, Patrice
J" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
mpo.gc.ca> Subject: RE: Customize my SQLPlus
login
Sent by:
[EMAIL PROTECTED]
03/26/02 10:23 AM
Please respond to
ORACLE-L
What happens if the user then issues a connect statement to connect to
another database?
It would be nice if there was a .sql file run every time a new connection
is
set, I don't know if that is the case in the 8i / 9i versions.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-----Original Message-----
Sent: Tuesday, March 26, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L
in your oracle /bin directory - you need to alter (Or create) a login.sql
file
here's what mine looks like - feel free to alter
/* **** start **** */
set heading on
set pause off
set pages 23
set lines 100
set verify off
set feedback on
set space 1
set serveroutput on size 1000000
set echo off
set termout off
column d_bname new_value d_bname
select user ||'@'||instance_name d_bname
from v$instance ;
set sqlprompt '&d_bname.> '
set termout on
set pause on
/* **** end **** */
Brian.
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
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).
