Re: Customizing SQL prompt??
Date: Wed, 31 Aug 1994 16:03:31 GMT
Message-ID: <brosalesCvEpxw.CI2_at_netcom.com>
kkc_at_nauvax.ucc.nau.edu writes:
>Hello again, I hope I am not bothering anyone with these stupid questions,
>but I find the expertise in this group far more rewarding than waiting days
>and days for a response from our VAR, and yes I have read the manuals, I just
>have a few stumbling blocks. Thank you for your patience (grovel, grovel)
>I am attempting to customize (like I don't have a million other things to do)
>the SQL prompt. I have modified login.sql and used the set sqlprompt command
>but I cannot seem to get SQL to accept the unix variable $ORACLE_SID in any
>form (%,&,',etc, etc), nor can I find the SQL system variable for db_name to
>assign sqlprompt. In other words, this isn't working:
> set sqlp $ORACLE_SID> (why?)
(1) SQLPlus does not evaluate environment variable. Thus your set command does not work.
(2) Put these statements in your login.sql
host echo "set sqlp $ORACLE_SID> " > /tmp/setsqlp.sql
_at_/tmp/setsqlp
Have fun.
Robert Rosales
Sonica Software Corp
brosales_at_netcom.com
Received on Wed Aug 31 1994 - 18:03:31 CEST