How to get the client, server name and IP address

SELECT SYS_CONTEXT ('useerenv', 'ip_address') from Dual - Client IP

SELECT UTL_INADDR.GET_HOST_ADDRESS from Dual - Server IP

SELECT SYS_CONTEXT ('useerenv', 'host') from dual - client name

SELECT UTL_INADDR.GET_HOST_NAME FROM DUAL - Server Name