If you don’t have access to the v$ views (as suggested by Quassnoi) there are two alternatives
select utl_inaddr.get_host_name from dual
and
select sys_context('USERENV','SERVER_HOST') from dual
Personally I’d tend towards the last as it doesn’t require any grants/privileges which makes it easier from stored procedures.