Identifying Host Names and IP Addresses in SQL and PL/SQL using Built-in Oracle Functionality

preview_player
Показать описание
This video demonstrates how to do DNS lookups and idenitify server and client host names and IP addresses in SQL and PL/SQL from Oracle. For more information see:

For information on Network Access Control Lists (ACLs) see:

Cameo by Mike Donovan

Cameo appearances are for fun, not an endorsement of the content of this video.
Рекомендации по теме
Комментарии
Автор

Hi, i'm asking about what command Allow me to query about the Current Machine' IP Address in Oracle 12c ???

mahamedramadan
Автор

From where oracle picks the value of DB server name and ip address using UTL_INADDR.get_host_name and UTL_INADDR.get_host_address, if i change IP address of DB server will UTL_INADDR will able to pick new IP address and from where, please suggest

mayanks
join shbcf.ru