Any Idea's ?

[nabeel]

I could make my SQL prompt like this USERNAME@DB1>, Where username is the DB username and DB1 is the global name of the DB. By editing the glogin file and adding the folowing enteries
define X=NotConnected
define Y=DBNAME

Column Usr New_Value X
Column DBName New_Value Y


Select SYS_CONTEXT('USERENV','SESSION_USER' ) Usr From Dual;

Select SYS_CONTEXT('USERENV','DB_NAME') DBNAME From Dual;

set sqlprompt '&X@&Y> '

But I want to get the alias from the tnsnames.ora file, if my tnsnames.ora file would have an entry like following then i would like to see my sql prompt like this SCOTT@DBTEST

DBTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 111.1.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9i)
)
)
Any ideas out there?

[adewri]

No ideas

[Thomasps]

If you are using Oracle 9i, use the "external tables" with tnsnames.ora as the data source and get the string from the tnsnames.ora. Then set the sqlprompt. I havn't tried, just a clue for you!

Thomas