This content has been marked as final. Show 2 replies
Rajapandian wrote:I can't understand what you exactly want ? But bellow code give you ip address
how to get machine physical address through sql query
is it possible to get?
Hope this helps
SELECT sys_context ('userenv','ip_address')-- INTO retval FROM dual;
If someone's response is helpful or correct, please mark it accordingly.*
I don't believe you can run a SQL Query to obtain the client MAC address. If you are trying to get the client MAC addres through Oracle Forms, then you can either use the WebUtil library or you can use a Java Bean. Take a look at WEBUTIL_CLIENTINFO package or A Java Bean to get the client machine information. You will need to make some configuration changes in order to use either option. There are numerous threads that address these configutation changes.
Hope this helps,