Network related columns (macaddr, cidr etc.) in Oracle?

We have used postgres in our application witch has a very nice set of network related column types along with functions package to operate on the开发者_开发技巧m.

And those columns, like macaddr, cidr etc. are extremely important, as they're used as a PKs or indexes in many tables.

(App is an cable modems provisioning system)

We're forced to move to the oracle instance, is there any way to force oracle to easily operate on network related column datatypes?

How we can handle with ie. getting mac addresses in different textual representations, from various dependent components?

• xx.xx.xx.xx.xx.xx
• xx.xx.x.x.xx.xx
• xxxx.xxxx.xxxx (cisco way)
• xxxxxxxxxxxx

same with cidrs etc.

Till now, postgres was able to handle that cases in very efficient and nice way...

(I'm new in Oracle RDBMS)

There are no native datatypes or supplied packages in Oracle for dealing with network structures like this that I am aware of. You'll likely have to create your own TYPE, perhaps using some of Oracle's Object Type functionality. This would seem to be a nice fit for the feature.

Here's an overview.