Re: Oracle server name in SQL prompt

Mike,
Hi. This might help you.This is what I use. The global name parameter gives me the servername also. Add this to your login file.

set numwidth 9
set linesize 300
set pagesize 24
variable user varchar2(32)
set termout off
column user noprint new_value user
select user from dual;
column user clear

• define rechner = 'UNBEKANNT'
• column rechnername noprint new_value rechner
• select rechnername from konfinfo;
• column rechnername clear column global_name noprint new_value instanz select global_name from global_name; column global_name clear set termout on set SQLPROMPT '&user:&instanz/SQL> '

This gives something like

SYSTEM:DBE.PENORAS03/SQL>
and penoras03 is my server

Michael Morley wrote:
>
> Anybody know how to put the name of the host server into the SQLPROMPT
> SQLPlus parameter? I can get the instance name but not the server name.
>
> Thanks.
>
> Mike M

Received on Tue Sep 28 1999 - 09:38:17 CDT