Re: Sqlprompt and Oracle Sid
From: Sameer Utrankar <utrankas_at_coned.com>
Date: 1996/04/22
Message-ID: <4lgrlc$nbu_at_ins3.coned.com>#1/1
Utrankas_at_coned.com (Sameer Utrankar) Received on Mon Apr 22 1996 - 00:00:00 CEST
Date: 1996/04/22
Message-ID: <4lgrlc$nbu_at_ins3.coned.com>#1/1
I select from v$parameter for db_name and use the retrieved value for set prompt comand in glogin.sql.
dewing_at_gasou.edu (David Ewing) wrote:
>I would like to set the sqlprompt to reflect the
>oracle sid if possible. For example, if a dba
>was in PROD, the sqlprompt might be
>something like SQL(PROD)>. How do you
>pass the oracle sid to the set sqlprompt in
>sql? I would like to put this in the overall
>login.sql script.
>Oracle 7.1.4 AIX 3.2.5 Rs6000-59H
Utrankas_at_coned.com (Sameer Utrankar) Received on Mon Apr 22 1996 - 00:00:00 CEST