Converting ip address in decimal to dot notation

[s8ig]

Hi,

Any idea how do i convert ip address stored in the oracle database in decimal format to dot notation?

Eg 173672972 (decimal) to 10.90.10.12

Please advise. Thanks

[debasisdas]

Kindly pass few more details . How exactly you are storing data.

[s8ig]

Kindly pass few more details . How exactly you are storing data.

The datatype is numeric(22)

The data is written to the oracle database by the product that i am using.

[debasisdas]

May i know the logic please, how 10.90.10.12 is stored as 173672972