Set constraint on column type?

[srichmond]

Hi, sorry for what I'm sure is a really stupid question but I've just recently started using Oracle.

Basically, I have a table called products containing the details of various products (mobile phones etc.) and each product is to have a rating between 1 and 5. I have a column called product_rating of type number(1,0) but don't know how to restrict it to between 1 and 5.

Thanks in advance for your help :)

[rski]

Use 'check constraint', see here

http://techonthenet.com/oracle/check.php