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_CASECHK CHECK ( Job =UPPER(Job))
11 CONSTRAINT MyEmp_Job_DESIGCHK
12 CHECK(Job IN('MANAGER','SALESMAN','ANALYST','CLERK','PRESIDE NT',NULL)),
13 Mgr NUMBER(4)
14 CONSTRAINT MyEmp_Mgr_FK REFERENCES MyEmp(Empno),
15 Hiredate DATE DEFAULT SYSDATE,
16 Sal NUMBER(7,2)
17 CONSTRAINT MyEmp_Sal_CHK CHECK ( Sal BETWEEN 2000 AND 100000),
18 Comm NUMBER(7,2) DEFAULT 0,
19 Deptno NUMBER(2)
20 CONSTRAINT MyEmp_Deptno_FK REFERENCES Dept(Deptno)
21* )
SQL> /
Table created.
SQL> INSERT INTO MyEmp
2 VALUES (
3 &EMPNO,
4 '&ENAME',
5 '&JOB',
6 &MGR,
7 '&HIREDATE',
8 &SAL,
9 &COMM,
10 &DEPTNO
11 )
12 /
Enter value for empno: 1000
Enter value for ename: NAME01
Enter value for job: PRESIDENT
Enter value for mgr:
Enter value for hiredate:
Enter value for sal:
Enter value for comm:
Enter value for deptno: 10
,
*
ERROR at line 6:
ORA-00936: missing expression
pls provide solution