Insert error: ORA-00936: missing expression

[t chaitanya]

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))
11 CONSTRAINT MyEmp_Job_DESIG CHK
12 CHECK(Job IN('MANAGER','S ALESMAN','ANALY ST','CLERK','PR ESIDENT',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

[rski]

Set null for below columns

Enter value for mgr: NULL
Enter value for hiredate: NULL
Enter value for sal: NULL
Enter value for comm: NULL