How to get windows username or IP address

admin

for windows username
Select sys_context('userenv','os_user') from dual;
exp:longi

for oracle username
Select sys_context('userenv', 'CURRENT_USER' ) from dual;
exp:IFSAPP

for IP address
select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual
exp:172.16.60.159

for host
SELECT host_name FROM v$instance; --
exp:erp(NTCHTEST)   ;oracle(NTCHERP)  ;F55C-LG(NTBDR)

for client
SELECT SYS_CONTEXT('USERENV','TERMINAL') FROM dual;
exp:F55C-LG