sexta-feira, 8 de janeiro de 2010

GET HOST ADDRESS FROM SERVER AND CLIENT

To Get server HOST NAME and HOST ADDRESS:
SET serveroutput on
BEGIN
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME); -- get local host name
DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS); -- get local IP addr
END;
/

Using SYS_CONTEXT to get client host address:
select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual;

Nenhum comentário:

Postar um comentário

Docker Remove ALL Containers and Images

Caution: This command destroy ALL images and Containers. Recovery only possible if you have backed up properly. - Delete all containers ...