Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Thursday, 5 January 2017

Find IP Address and Host Name using PL/SQL

Using the UTL_INADDR package, a PL/SQL subprogram can determine the host name of the local system or the IP address of a given host name.

Example:

SET serveroutput on
BEGIN
  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME);  -- get local host name  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS);  -- get local IP addr  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS('www.oracle.com'));  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME('141.146.9.91'));

END;
Share this article :

3 comments:

  1. Hi,
    How to round buttons in oracle forms 12c.

    ReplyDelete
  2. A LAN (Local Area Network) is a group of computers and network devices connected together, usually within the same building.myip

    ReplyDelete
  3. Each address, when broken into segments, represents different country and region codes. wearable technology definition

    ReplyDelete