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 :

6 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
  4. This will demonstrate to you what number of milliseconds the information takes to achieve your VPN server.what is my router ip

    ReplyDelete
  5. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. https://192-168-i-i.com

    ReplyDelete
  6. When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. 192.168.49

    ReplyDelete