Skip to main content
1 of 3
Pydi Raju
  • 514
  • 4
  • 9
  • 18

Convert Decimal to IP Address in oracle

iam new to oracle i need a function or query to convert Decimal to IP Address.

Example:Present my ip_address column like below

select ip_address from test_ip;

    ip_address

     173015430
     173015318
     927815779

I need result like below

select ip_address from test_ip;

         ip_address
        10.80.1.134
        10.80.1.22
        55.77.88.99

i can able to do in mysql by using INET_NTOA function. Same thing i want in oracle .

Please help.

Pydi Raju
  • 514
  • 4
  • 9
  • 18