Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Create a table with check constraint

SQL> SQL> create table employees   2  ( empno      NUMBER(4)    constraint E_PK   3                            primary key   4                            constraint E_EMPNO_CHK   5                            check (empno > 7000)) ; Table created. SQL> SQL> drop table employees; Table dropped.