RE: Customize my SQLPlus login

Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight

(INV-SYSTEM)>show user
USER is "SYSTEM"
(INV-SYSTEM)>connect elvis_at_inv
Enter password: *****
Connected.
(INV-SYSTEM)>@login
(INV-ELVIS)> or create a script with the login name and sid that calls login.sql right afterwards.

Lisa Koivu
Oracle Database Baby Oven.
Fairfield Resorts, Inc.
954-935-4117

> -----Original Message-----
> From: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Sent: Tuesday, March 26, 2002 12:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Customize my SQLPlus login
>
> 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
> Subject: Re: Customize my SQLPlus login
>
>
> 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: Brian_McQuillan_at_gelco.com
>
> 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: ListGuru_at_fatcity.com (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: BoivinP_at_mar.dfo-mpo.gc.ca
>
> 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: ListGuru_at_fatcity.com (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: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.com

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: ListGuru_at_fatcity.com (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).