Member Avatar for mir77

Dear friends,


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

  • 2 Contributors
  • 2 Replies
  • 86 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by debasisdas

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

use the following

select sys_context( 'userenv', 'ip_address' ) from dual
Member Avatar for debasisdas

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

Edited by debasisdas because: n/a
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.