Sometimes we need to add ulterior constraints to the table we define. The ALTER TABLE statement enables us to do this. There are several types of constraints we can add. If we want to ensure that all ...

I think the logic is too complicated for a CHECK constraint, and I haven't managed to get a user-defined function to work it that context so it may not be possible that way.

SCHED_NAME VARCHAR2(120) DEFAULT 'OCS_SCHEDULER' NOT NULL, IS_NONCONCURRENT VARCHAR2(1) default 'N' NOT NULL, IS_UPDATE_DATA VARCHAR2(1) default 'N' NOT NULL, CONSTRAINT POLL_JOB_DETAILS_PK PRIMARY ...