GET_HOST_NAME,GET_HOST_ADDRESS

These sql codes below provides us to see our instance's database's host name and host address.

1-)Press F5 to see script output.

2-)Other possible use of utl_inaddr.get_host_name and utl_address.get_host_address