월간 보관물: 2011 2월

Oracle “with check option” syntax

Don Burleson     A “with check option” is designed for updatable views whereas a “check constraint” (coinstraint_type “V”) specifies valid values for an individual column:   region_name       varchar(5), CONSTRAINT check_region CHECK (region_name in ‘north’,’south’,’east’,’west’)   The “with check … 계속 읽기

카테고리: Oracle | 댓글 남기기