Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: a database name as sql prompt

Re: a database name as sql prompt

From: Ronald Hijdra <hijdra_at_icim.nl>
Date: 1997/06/16
Message-ID: <33A50772.46C0@icim.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US