You can use check constraint on column which will check date is grater than 1 jan 2007 or you can create trigger before insert or update which will check that date is grater than 1 jan 2007 .
easy way to use check constraint on column
below is example
CREATE TABLE test
log_date DATE CHECK(log_date > to_date('01/01/2007' , 'dd/mm/yyyy'))
if table already exists then use
ALTER TABLE test
ADD CONSTRAINT con_chk CHECK(log_date > to_date('01/01/2007' , 'dd/mm/yyyy'))
but for this command to run there should not be single row having date less than 1 jan 2007
Last Wiki Answer Submitted: March 12, 2008 4:38 am by BlueStar90 pts.