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.