RE: unsigned attribute

In oracle you could use CHECK constraint:

 field_name integer check(field_name between 0 and 255)

Igor
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Simone Saravalli Sent: Friday, April 07, 2006 9:41 AM
To: Igor Neyman
Cc: oracle-l
Subject: Re: unsigned attribute

Yes, for example, in mysql the tinyint datatype can store small integer values from -128 to 127 (this is the signed range) or from 0 to 255 (this is the unsigned range) with the UNSIGNED attribute. So, in mysql I can write:

...
field_name tinyint [other_attr], # values from -128 to 127 ...

or

...
field_name tinyint UNSIGNED [other_attr], # values from 0 to 255 ...

Has Oracle something similar?

Simone Saravalli

2006/4/7, Igor Neyman <ineyman_at_perceptron.com>:
> Obviousle, "for those not familiar with MeSQL".

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Simone Saravalli
> Sent: Friday, April 07, 2006 9:13 AM
> To: oracle-l
> Subject: unsigned attribute
>
> Hi all,
> I'm looking for something like mysql unsigned constraint with
> oracle, but I didn't find it. I found many kind of constraints like
> primary key, foreign key, not null, etc, but not for unsigned. Does it

> exist in oracle or not?
>
> Thank you, Simone Saravalli
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

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



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