Sqlprompt and Oracle Sid
From: David Ewing <dewing_at_gasou.edu>
Date: 1996/04/22
Message-ID: <dewing.61.000E2FAF_at_gasou.edu>#1/1
Date: 1996/04/22
Message-ID: <dewing.61.000E2FAF_at_gasou.edu>#1/1
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 Received on Mon Apr 22 1996 - 00:00:00 CEST