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