Re: SQL-Plus

From: <Winnie_Liu_at_infonet.com>
Date: Tue, 6 Jun 2000 14:06:15 -0700
Message-Id: <10520.107970@fatcity.com>

Add this to glogin.sql file and you will get a prompt like 10:33:43 scott (proddb @servera) >

set time on
set serveroutput on size 1000000 format wrapped column sid2 new_value osid noprint
column usr new_value ousr noprint
column machin new_value omach noprint

Redefine col width for all users for global_name field; default is 2000 chars. column global_name format a20 column user format a15
Customize prompt only, but no banner message

set termout off
select user usr from dual;

Trim ".WORLD" off of "AISI.WORLD" global_name; rename field as "sid2" select substr(global_name,1,INSTR(global_name,'.')-1) sid2 from global_name;
- Get the machine name

select machine machin from v$session where program like 'oracle%(PMON)%';

Resume normal sqlplus display set heading on set feedback on set termout on
Set new prompt; "&" means display current value of variable set sqlprompt '&ousr(&osid @&omach) > '

"salu Ullah" <salu_ullah_at_hotmail.com> on 06/06/2000 02:49:33 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: SQL-Plus

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:06:15 CDT