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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.