Customizing SQL prompt??

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?)

Your wisdom can know no equal! (grovel, grovel)

Thank You, Kathy Carmichael
kcarmich_at_coco.cc.az.us Received on Wed Aug 31 1994 - 01:57:14 CEST