Re: VARIABLE FOR MACHINE ID/TERMINAL ID

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Wed, 21 Feb 2001 06:42:21 GMT
Message-ID: <20010221.6422132@slu40xxx.hae.hydro.com>

You can use USERENV('TERMINAL') (not a variable, but a function), or in

Oracle 8 style SYS CONTEXT('USERENV', 'TERMINAL'):

select userenv('terminal') from dual

select sys context('userenv','terminal') from dual

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2001-02-20, 17:54:47, schreef "John" <john millhouse_at_yahoo.com> over het
thema VARIABLE FOR MACHINE ID/TERMINAL ID:

> I need to know if there is a hardcoded variable for Machine Id for

example
> like (user, sysdate) To find out the name of the Terminal. Instead o
f
> doing a select from V $SESSION?
Received on Wed Feb 21 2001 - 00:42:21 CST