登陆:
Connect SYS/****@WWW.PRACTEMP.COM AS SYSDBA
Describe emp;
Name
Null
Type
EMPNO
NOT NULLNUMBER(4)
ENAME
VARCHAR2(10)
JOB
VARCHAR2(9)
MGR
NUMBER(4)
HIREDATE
DATE
SAL
NUMBER(7,2)
COMM
NUMBER(7,2)
DEPTNO
NOT NULLNUMBER(2)
insert into emp values(7839, KING, PRESIDENT, NULL, 17-NOV-81, 5000,NULL,10);
insert into emp values(7698, BLAKE,MANAGER, 7839, 01-MAY-81, 2850,NULL,30);
insert into emp values(7782, CLARK,MANAGER, 7839, 09-JUN-81, 2450,NULL,10);
insert into emp values(7566, JONES,MANAGER, 7839, 02-APR-81, 2975,NULL,20);
insert into emp values(7654, MARTIN, SALESMAN,7698, 28-SEP-81, 1250,1400,30);
insert into emp values(7499, ALLEN,SALESMAN,7698, 20-FEB-81, 1600,300, 30);
insert into emp values(7844, TURNER, SALESMAN,7698, 08-SEP-81, 1500,0, 30);
insert into emp values(7900, JAMES,CLERK, 7698, 03-DEC-81,950,NULL,30);
insert into emp values(7521, WARD, SALESMAN,7698, 22-FEB-81, 1250,500, 30);
insert into emp values(7902, FORD, ANALYST, 7566, 03-DEC-81, 3000,NULL,20);
insert into emp values(7369, SMITH,CLERK, 7902, 17-DEC-80, 800, NULL,20);
insert into emp values(7788, SCOTT,ANALYST, 7566, 09-DEC-82, 3000,NULL,20);
insert into emp values(7876, ADAMS,CLERK, 7788, 12-JAN-83, 1100,NULL,20);
insert into emp values(7934, MILLER, CLERK, 7782, 23-JAN-82, 1300,NULL,10);
下面是错误:
insert into emp values(7839, KING, PRESIDENT, NULL, 17-NOV-81, 5000,NULL,10);
*
ERROR位于第一行:
ORA-00984:列在此处不允许
每一行都有同样的错误,我想可能是系统默认的时间和我输入的格式不相符,(现在知道系统默认的日期格式是: DD-Mon-YY),以后遇见同样类似的错误怎么查帮助,好像这个帮助我现在用起来不是怎么顺手!!
请大家帮忙,thx.
|