简单问题:如何限定值的范围

[lubber]

oracle中没有enum,怎么限定值的范围啊?比如某字段的值只能为1或2,怎么做啊?

[welyngj]

create table x ( col1 a number(1) ,constraint ck_col1 check (col1 in (1,2)))

[guangli_zhang]

alter table test add constraint constraint_name check(code in (1,2))