Oracle Database Discussions

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!

Reproducing postgres "inet" datatypes and operators?

656117Aug 21 2008 — edited Feb 11 2011

Hi,

I need to migrate an application from postgres to oracle 10, and I am looking for a way to reproduce the functionality of the "inet" datatypes in oracle. Inet data types store i.p. addresses and netmasks and allow to do operations on them like testing wheter an address is contained in a given netword/netmask.

How would I do that in Oracle? As far as I can tell there isn't a similar datatype for oracle, so I guess I will need to create procedures/functions on the db to do the bit manipulation. Does oracle have bitwise AND/OR operators?

Thanks in advance,
A.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2011

Added on Aug 21 2008

#database-and-application-migrations, #management

2 comments

2,985 views