how to use with check contraint with multiple options
900105Nov 14 2011 — edited Nov 14 2011Hi I like to correct the following codes,,,
I want to insert only 'Male' or 'female' in gender column. If anyone tries to insert otherthan male or female, column shoud not insert on it.
For that the following code is correct or not?
create table gender (gender varchar2(10) check (gender in male,female));
thanks in advance