Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Check constraint with MOD function

SQL> SQL> create table departments   2  ( deptno NUMBER(2)     constraint D_PK   3                         primary key   4                         constraint D_DEPTNO_CHK   5                         check (mod(deptno,10) = 0)   6  ) ; Table created. SQL> SQL> drop table departments; Table dropped. SQL>