Current PC name in ORACLE 10g

A very simple code to get name of PC.



SELECT USERENV('TERMINAL') FROM DUAL;

Update : using the following code to get more info :

select    sys_context('USERENV','SESSIONID'),

   sys_context('USERENV','HOST'),

   sys_context('USERENV','IP_ADDRESS') from dual



Thanks to Arab OUG