Obtain machine IP Address using Oracle SQL command

July 31, 2013

I never know this function has exist until I was required to explore Oracle APEX to design a website. Here is the code, which can get an IP address of machine and the value can be store into a database or pass it into other variable for processing, or whatever your programming do.
select sys_context('userenv','ip_address')  from dual
Have fun.

1 comment:

  1. would like to thank the author for sharing this such of wonderful and most impotently the helping information with us about oracle apex training in hyderabad

    ReplyDelete

ShareThis