Re: SQL-Plus

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).
Received on Tue Jun 06 2000 - 16:53:58 CDT