Display Instance in SQL*Plus Prompt

Follks,

Anyone got a script that displays the instance name in the SQL*Plus prompt when you first sign on. I figure that glogin.sql has to be modified and I've got a semblence of an idea but can't get it to work.

I'm doing select value from v$parameter where name = 'db_name'. How do I get the value into a variable so that I can use it in the set sqlprompt clause?

Thanks

mkb

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!