How to get localhost in windiws.......

[mohit_sharan]

How to get localhost of oracle 8.1.7 in windiws 2000 through PL/SQL code...

[Giani]

Originally posted by mohit_sharan
How to get localhost of oracle 8.1.7 in windiws 2000 through PL/SQL code...

Don't know if this is the right answer :
select sys_context('USERENV','TERMINAL') from dual;
or
select sys_context('USERENV','IP_ADDRESS') from dual ;
HTH

[mohit_sharan]

Hi,

I got the answer . The query is :

select host_name from v$instance;