Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Help Data-Types

Re: Help Data-Types

From: Mikito Harakiri <mikharakiri_at_yahoo.com>
Date: 18 Aug 2002 09:57:58 -0700
Message-ID: <bdf69bdf.0208180857.5980ec69@posting.google.com>


"Dave" <dave_at_dmcomm.com> wrote in message news:<_Ug79.27$Tl4.10801289_at_news.incc.net>...
> Just a quick question on a datatypes since I'm a young novice.
> What the heck would an IP address go under? Text? Integer (long, short?) ??
>
> Thanks for the help.
> D

Four integer columns? Then, enforsing constraints and querieng is the simplest of all. Alternatively, it could be just a single integer:

a3*256^3+a2*256^2+a1*256^1+a0

See also a similar discussion about URL datatype at dbdebunk.com. Received on Sun Aug 18 2002 - 11:57:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US