Re: sqlplus prompt

From: Dave Wotton <Dave.Wotton_at_it.camcnty.gov.uk>
Date: 1997/05/01
Message-ID: <5kaivh$4lo@dns.camcnty.gov.uk>#1/1

Rich Headrick <r4bhead_at_pacbell.com> wrote:
>How does one change the default sqplus prompt to be = to current SID?
>
>Please email.
>
>rich

We do it by including the line:

start $ORACLE_HOME/sqlplus/admin/$ORACLE_SID.sql

in $ORACLE_HOME/sqlplus/admin/glogin.sql

where, for example, the file $ORACLE_HOME/sqlplus/admin/live.sql contains

set SQLPROMPT Live-SQL>

Obviously, we have one such file for each $ORACLE_SID

Dave. Received on Thu May 01 1997 - 00:00:00 CDT