oracle -00947,ORA-00947: not enough values

ORA-00947:

not enough values(没有足够的值)

比如：

SQL> insert into

emp values(1111,'bbb','builder',100,12-JAN-90,100000);

insert into emp

values(1111,'bbb','builder',100,12-JAN-90,100000)

*

ERROR at line 1:

ORA-00947: not enough values

SQL>insert into emp

values(7777,'bbb','CLERK','7566','21-JAN-98',1000,100,10);

1 row created.

SQL> select *

from emp;

EMPNO ENAMEJOBMGR HIREDATESALCOMMDEPTNO

----------

---------- --------- ---------- --------- ---------- ---------- ----------

7369 SMITHCLERK7902 17-DEC-8080020

7499 ALLENSALESMAN7698 20-FEB-81160030030

7521 WARDSALESMAN7698 22-FEB-81125050030

7566 JONESMANAGER7839 02-APR-81297520

7654 MARTINSALESMAN7698 28-SEP-811250140030

7698 BLAKEMANAGER7839 01-MAY-81285030

7782 CLARKMANAGER7839 09-JUN-81245010

7788 SCOTTANALYST7566 19-APR-87300020

7839 KINGPRESIDENT17-NOV-81500010

7844 TURNERSALESMAN7698 08-SEP-811500030

7876 ADAMSCLERK7788 23-MAY-87110020

EMPNO ENAMEJOBMGR HIREDATESALCOMMDEPTNO

----------

---------- --------- ---------- --------- ---------- ---------- ----------

7900 JAMESCLERK7698 03-DEC-8195030

7902 FORDANALYST7566 03-DEC-81300020

7934 MILLERCLERK7782 23-JAN-82130010

7777 bbbCLERK7566 21-JAN-98100010010

15 rows selected.