Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Como extrair IP pelo hostname

JontsJan 2 2019 — edited Jan 14 2019

Tudo bem?

Sou iniciante no contexto de PL\SQL Oracle.

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

Tenho uma tabela de log que mostra quantas vezes o computador acessou uma aplicação, mas mostra somente o nome do computador.

select UPPER(ds_maquina) ds_maquina,
count(ds_maquina) qtd_estacao
from Log_Acesso where dt_acesso between '01/10/2018' AND '10/10/2018'
and ds_maquina is not null
group by UPPER(ds_maquina)
order by UPPER(ds_maquina)

Pesquisei e achei SELECT UTL_INADDR.get_host_address mas não sei como poderia montar o select.

Como posso mostrar o IP pelo nome do hostname? Queria criar uma coluna IP ao lado do host.

This post has been answered by J.Laurindo Chiappa on Jan 2 2019
Jump to Answer

Comments

Post Details

Added on Jan 2 2019
8 comments
6,835 views