Re: SQL*PLUS / Client connection

To remind myself which database I am logged into and which user I am logged in as, I have the following in my glogin.sql file.

column glob_user new_value usr noprint
select user||'@'
glob_user
  from global_name;
column glob_user clear
column glob_db new_value db noprint
select value||'>'
glob_db
  from v$parameter where name='db_name'; set sqlprompt '&usr&db'
column glob_db clear

Note that if you disconnect and reconnect, glohin.sql dies not run again, so the prompt does not change.

=?iso-8859-1?Q?Gr=E9gory?= GRIN (grin_at_club-internet.fr) wrote:
: I'm looking for a method to add a banner or to modify the prompt at any =

: connection on my ORACLE 7.3.4 Dec Unix Server from SQL*PLUS with
: a windows client station.
: Thanks
: Gr=E9gory GRIN

-- Received on Mon Nov 09 1998 - 15:27:28 CST