67,542
社区成员
发帖
与我相关
我的任务
分享求一SQL 语句？？？？
小弟在 ORACLE 9 ，里有一个表 要用到 两个属性一起来 作 主键，怎么写 SQL 啊？
CREATE TABLE "TB_GOODS_BUYER" ("GOODS_ID" VARCHAR2(10)
NOT NULL, "BUYER_ID" VARCHAR2(10) NOT NULL, PRIMARY KEY("GOODS_ID"),
PRIMARY KEY("BUYER_ID")）
TABLESPACE "MARKET" ;
不行啊？？？？？
CREATE TABLE "TB_GOODS_BUYER" ("GOODS_ID" VARCHAR2(10)
NOT NULL, "BUYER_ID" VARCHAR2(10) NOT NULL, PRIMARY KEY("GOODS_ID"),
PRIMARY KEY("BUYER_ID")）
TABLESPACE "MARKET" ;
不行啊？？？？？
...全文
请发表友善的回复…
发表回复
ladofwind 2004-10-09
- 打赏
- 举报
create TABLE "TB_GOODS_BUYER" (
"GOODS_ID" VARCHAR2(10) NOT NULL,
"BUYER_ID" VARCHAR2(10) NOT NULL,
PRIMARY KEY("GOODS_ID","BUYER_ID"));
"GOODS_ID" VARCHAR2(10) NOT NULL,
"BUYER_ID" VARCHAR2(10) NOT NULL,
PRIMARY KEY("GOODS_ID","BUYER_ID"));
micker 2004-10-09
- 打赏
- 举报
ChDw(米) 的是对的啊！
ChDw 2004-10-09
- 打赏
- 举报
CREATE TABLE "TB_GOODS_BUYER" (
"GOODS_ID" VARCHAR2(10) NOT NULL,
"BUYER_ID" VARCHAR2(10) NOT NULL,
PRIMARY KEY("GOODS_ID","BUYER_ID"));
"GOODS_ID" VARCHAR2(10) NOT NULL,
"BUYER_ID" VARCHAR2(10) NOT NULL,
PRIMARY KEY("GOODS_ID","BUYER_ID"));
