Dear friends,


Plz tell me , how can i detect the pc's ip address from oracle software dynamically?

use the following

select sys_context( 'userenv', 'ip_address' ) from dual

Use the following if you want the same in PL/SQL code.

BEGIN
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME); -- Local machine/host name
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS); -- IP address of host
END;

The above code works oracle version 10(g) onwards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.