Wednesday, August 08, 2007

Oracle DB 10g EX SQL - create table - syntax to add Check

CREATE TABLE student(
student_no NUMBER(3) NOT NULL,
age NUMBER(2) CHECK(age>18),
gender CHAR(1) CHECK(gender='m' or gender='f') NOT NULL
);

No comments: