RE: SQL-Plus

From: Ngo, Tan <TNGO_at_EFTIA.com>
Date: Thu, 8 Jun 2000 13:52:15 -0400
Message-Id: <10522.108261@fatcity.com>

Salu,

Which script works, can you tell me?

> -----Original Message-----
> From: salu Ullah [mailto:salu_ullah_at_hotmail.com]
> Sent: Thursday, June 08, 2000 11:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).

________________________________________________________________________

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

Received on Thu Jun 08 2000 - 12:52:15 CDT