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 :

26 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
  7. I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work. https://192-168-i-i.com/

    ReplyDelete
  8. Thanks for the valuable information and insights you have so provided here.

    192.168.l.l
    192.168 l 254
    192.168.0.1

    ReplyDelete

  9. 192.168.1.254

    192.168.l.254

    192.168.1.1

    192.168.o.1

    192.168.l0.1

    192.168.l.l

    192.168.o.1

    is a Private IP address and most powerful universal IP addresses, this is used in the Linksys router.

    ReplyDelete
  10. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  11. 192.168.ll is one of the most common IP addresses a router network.

    ReplyDelete
  12. Each gadget that necessities to speak with the Internet needs a one of a kind IP address. Without this, the Internet doesn't have a clue where to send answers to your solicitations.
    http //jiofi.local.html

    ReplyDelete
  13. Absolutely fantastic posting! Lots of useful information and inspiration, both of which we all need!Relay appreciate your work.192.168.1.254

    ReplyDelete


  14. 192.168.10.1
    192.168.0.1

    This configuration can also be used for devices like Router, Modem etc. and they are all having the initial IP address

    ReplyDelete
  15. As a seller of legal steroids, you can buy Crazy Bulk products, explore stacks and finally get the body you’ve always wanted creative business names

    ReplyDelete
  16. Yes, shared hosting might have done good things for you and your site but a website growing in traffic, having regular viewers and patrons, ramping up the data and bandwidth usage deserve a better host. https://onohosting.com/

    ReplyDelete
  17. Windows and UNIX are the prominent types of operating system platforms, which allow a user to host their website on Windows Platform can be an excellent choice and there are a number of advantages associated with Windows Hosting. Windows is a popular operating system and could turn out to be very precious and helpful for your online business. It is one of the top web hosting operating systems giving you several advantages that meet your web hosting requirements. https://hostinglelo.in/

    ReplyDelete
  18. In other words, without any limits, you can get access to any information over the internet with the use of proxy websites. These proxy websites are simply called as proxies. his comment is here

    ReplyDelete
  19. The training has exposed me to various aspects of computer networking, IP routing and IP switching and how to manage a network from an office network to larger networks. best ip tracker website

    ReplyDelete
  20. buy youtube views Xbox 360 games are quite par of excellence due to their quality graphics and digital sound system. However, the Xbox 360 games are pricier due to their rich quality. As like any DVD, these games are also prone to scratches. Even a single scratch may cause damage of the game.

    ReplyDelete
  21. A center is actually a multiple port repeater. A repeater gets a computerized sign and yet again intensifies or recovers that sign, and afterward advances the advanced sign out all dynamic ports without checking out any information. A functioning center point does likewise. https://onohosting.com/

    ReplyDelete