急!急!急!各位大虾!请问在Oracle中如何定义外键组?? ALTER TABLE yADD CONSTRAINT fk_y FOREIGN KEY (aaa, bbb, ccc)REFERENCES x (aaa,bbb,ccc) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 or create table y(aaa char(6), bbb char(6), ccc char(6), ggg char(6), hhh char(6), lll char(6), primary key (aaa,bbb,ccc,ggg), FOREIGN KEY (aaa, bbb, ccc)REFERENCES x (aaa,bbb,ccc)) 大哥 ,不行呀!能不过!error : 确少右(莫明其妙!不知道怎么会有这样的错!!! CREATE TABLE dept_20 (employee_id NUMBER(4) PRIMARY KEY, last_name VARCHAR2(10), job_id VARCHAR2(9), manager_id NUMBER(4) CONSTRAINT fk_mgr REFERENCES employees ON DELETE SET NULL, hire_date DATE, salary NUMBER(7,2), commission_pct NUMBER(7,2), department_id NUMBER(2) CONSTRAINT fk_deptno REFERENCES departments(department_id) ON DELETE CASCADE ); 我的是9i, test is OK.create table x(aaa char(6), bbb char(6) , ccc char(6) , ddd char(6), eee char(6), fff char(6), primary key (aaa,bbb,ccc))/create table y(aaa char(6), bbb char(6), ccc char(6), ggg char(6), hhh char(6), lll char(6), primary key (aaa,bbb,ccc,ggg), FOREIGN KEY (aaa, bbb, ccc) REFERENCES x(aaa,bbb,ccc))/ 初学SQL冒昧求教! 新手:oracle 两表联查的sql不会写了 一个存储老是有问题,请大家帮忙解决一下 给表增加一个记录,默认值是字符1,如何写 oracle的初学者问题 求几条SQL语句!! 哪位高手给指点这个SQL应该怎么写 继续问 关于读一致的问题(ado) 如何在存储过程里写建表的语句?(高手请指点) oracle的sql问题 大家好 为什么导出操作已经提交 在作业里有 却没有执行
create table y
(aaa char(6),
bbb char(6),
ccc char(6),
ggg char(6),
hhh char(6),
lll char(6),
primary key (aaa,bbb,ccc,ggg),
FOREIGN KEY (aaa, bbb, ccc)
REFERENCES x (aaa,bbb,ccc)
)
能不过!error : 确少右(莫明其妙!不知道怎么会有这样的错!!!
(employee_id NUMBER(4) PRIMARY KEY,
last_name VARCHAR2(10),
job_id VARCHAR2(9),
manager_id NUMBER(4) CONSTRAINT fk_mgr
REFERENCES employees ON DELETE SET NULL,
hire_date DATE,
salary NUMBER(7,2),
commission_pct NUMBER(7,2),
department_id NUMBER(2) CONSTRAINT fk_deptno
REFERENCES departments(department_id)
ON DELETE CASCADE );
create table x
(aaa char(6),
bbb char(6) ,
ccc char(6) ,
ddd char(6),
eee char(6),
fff char(6),
primary key (aaa,bbb,ccc)
)
/
create table y
(aaa char(6),
bbb char(6),
ccc char(6),
ggg char(6),
hhh char(6),
lll char(6),
primary key (aaa,bbb,ccc,ggg),
FOREIGN KEY (aaa, bbb, ccc) REFERENCES x(aaa,bbb,ccc)
)
/