Oracle 10g SQL
CREATETABLEteachers(teacher_idNUMBER(5)CONSTRAINTteacher_pkPRIMARYKEY,nameVARCHAR2(8)...
CREATE TABLE teachers (
teacher_id NUMBER(5)
CONSTRAINT teacher_pk PRIMARY KEY,
name VARCHAR2(8) NOT NULL,
title VARCHAR2(6),
hire_date DATE DEFAULT SYSDATE,
bonus NUMBER(7,2),
wage NUMBER(7,2),
department_id NUMBER(3)
CONSTRAINT teachers_fk_departments
REFERENCES departments(department_id)
)
运行后提示 第十一行出现错误：
ORA-00904：“DEPARTMENTT-ID”:标示符无效 展开
teacher_id NUMBER(5)
CONSTRAINT teacher_pk PRIMARY KEY,
name VARCHAR2(8) NOT NULL,
title VARCHAR2(6),
hire_date DATE DEFAULT SYSDATE,
bonus NUMBER(7,2),
wage NUMBER(7,2),
department_id NUMBER(3)
CONSTRAINT teachers_fk_departments
REFERENCES departments(department_id)
)
运行后提示 第十一行出现错误：
ORA-00904：“DEPARTMENTT-ID”:标示符无效 展开
1个回答
展开全部
看departments表里是否有department_id这个字段，也许不是叫这个名字
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
