Re: SQL-Plus

Thanks,

Its working.

Salu

>From: "Veera Prasad" <vprasad_at_olf.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: SQL-Plus
>Date: Tue, 06 Jun 2000 15:04:18 -0800
>
>Put the below stuff into your glogin.sql file.
>
>column id_plus_exp format 990 heading i
>column parent_id_plus_exp format 990 heading p
>column plan_plus_exp format a60
>column object_node_plus_exp format a8
>column other_tag_plus_exp format a29
>column other_plus_exp format a44
>set termout off
>define new_prompt='nolog'
>column value new_value new_prompt
>select username || ': ' || substr(global_name,1,instr(global_name,'.')-1)
>value from user_users, global_name;
>set sqlprompt "&new_prompt>"
>set termout on
>
>start sqlplus and check yourself any difference is there than before
>like showing up username: followed by database name. if u are
>not able to see database name then please update table global_name
>and set global_name = database_name.domain_name as user sys ok.
>
>Veera
>
>if u have any problems please lemme know.
>
>
>salu Ullah wrote:
>
> > Hello,
> >
> > Is there a script or code that i can add in my glogin file so that when
>ever
> > i connect to sql plus shows both the user name & database name.
> > Thanks in advance.
> >
> > Salu
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: salu Ullah
> > INET: salu_ullah_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Author: Veera Prasad
> INET: vprasad_at_olf.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).