1 CREATE TABLE MyEmp
2 (
3 Empno NUMBER(4)
4 CONSTRAINT MyEmp_Empno_PK PRIMARY KEY
5 CONSTRAINT MyEmp_Empno_CHK CHECK( Empno BETWEEN 1 AND 9999 ),
6 Ename VARCHAR2(9)
7 CONSTRAINT MyEmp_Ename_NN NOT NULL
8 CONSTRAINT MyEmp_Ename_CHK CHECK ( Ename =UPPER(Ename)),
9 Job VARCHAR2(9)
10 CONSTRAINT MyEmp_Job_CASEC HK CHECK ( Job =UPPER(Job))...