RE: unsigned attribute
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <s.saravalli@xxxxxxxxx>
- Date: Fri, 7 Apr 2006 09:48:45 -0400
In oracle you could use CHECK constraint:
field_name integer check(field_name between 0 and 255)
Igor
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx>:
> Obviousle, "for those not familiar with MeSQL".
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
