)
Sent by: Subject: SID on sqlplus prompt?
[EMAIL PROTECTED]
om
Title: RE: SID on sqlplus prompt?
I use this as well but it only works going through Sqlplus. If you want to change connections while you are in sqlplus by entering sql Connect username@dbname, then the sid/username will not change on the sql prompt. To make the connection change show, add
to:
root@fatcity.Subject: SID on sqlplus prompt?
com
to:
Sent by: Subject: RE: SID on sqlplus prompt?
root@fatcity
Hi,
Is there a way to get the SID or database name
displayed in the command prompt of SQL*Plus? Can this
be generated dynamically if I perform a CONNECT
user/pw ?
Thanks!
-w
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail -
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
:
Sent by: Fax to:
root@fatcity.Subject: SID on sqlplus prompt?
com