RE: data type for storing IP address?

Nope. No such datatype exists.

-Mark

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vordos, Suzy Sent: Tuesday, April 01, 2008 2:07 PM
To: oracle-l_at_freelists.org
Subject: data type for storing IP address?

Hello,

PostgreSQL offers data types for storing IPv4, IPv6, and MAC network addresses. Does Oracle yet have a similar data type that understands IP addresses (and/or IP address ranges such as "192.168.0.0/16") so that greater-than, less-than, between, and other comparisons can be made?

Thanks,
Suzy

This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 01 2008 - 13:20:54 CDT