Re: a database name as sql prompt

Abiy Alemu wrote:
>
> Has some one an idea as to how to have the database name as the sql
> prompt when connected to sql plus ?
>
> Thank you!
>
> |-----------------------------------------------------------------------------|
> | If the only tool you have is a | Abiy Alemu abiy_at_biotec.jouy.inra.fr |
> | hammer, everything in the world | 9, avenue calmels |
> | seems like a nail.____________________| 92270 Bois colombes (France)________|

This is what you can do:

SQL*plus checks the login.sql or glogin.sql file somewhere in the Oracle directory structure. In this file you can select the database name from v$database en set the sqlprompt. You can also add the user name from sys.dual.

Hope this helps

Ronald Hijdra
SE/DBA EDS NL Received on Mon Jun 16 1997 - 00:00:00 CDT