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