ORA-00984: column not allowed here

ORA-00984错误:列在此处不允许

当数据以char的形式存在时,应加单引号,则插入数据库就不会出现类似错误.

比如：

SQL> insert into emp values(7777,'bbb','CLERK',7566,21-JAN-98,1000,100,30);

insert into emp values(7777,'bbb','CLERK',7566,21-JAN-98,1000,100,30)

                                                  *

ERROR at line 1:

ORA-00984: column not allowed here

SQL>  insert into emp values(7777,'bbb','CLERK','7566','21-JAN-98',1000,100,10);

1 row created.

结果：

SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO

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

      7369 SMITH      CLERK           7902 17-DEC-80        800                             20

      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30

      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30

      7566 JONES      MANAGER         7839 02-APR-81       2975                         20

      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400       30

      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                       30

      7782 CLARK      MANAGER         7839 09-JUN-81       2450                        10

      7788 SCOTT      ANALYST         7566 19-APR-87       3000                         20

      7839 KING       PRESIDENT            17-NOV-81       5000                            10

      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0       30

      7876 ADAMS      CLERK           7788 23-MAY-87       1100                      20

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO

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

      7900 JAMES      CLERK           7698 03-DEC-81        950                              30

      7902 FORD       ANALYST         7566 03-DEC-81       3000                          20

      7934 MILLER     CLERK           7782 23-JAN-82       1300                            10

      7777 bbb        CLERK           7566 21-JAN-98       1000           100              10

15 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30606702/viewspace-1958907/，如需转载，请注明出处，否则将追究法律责任。