怎样为一个表设置主键和外键??要完整的SQL语句!!!

你真懒!

ALTER TABLE JL.EMP
ADD CONSTRAINT SYS_C005888
FOREIGN KEY (JOB)
REFERENCES JL.EMP_P (JOB)
ON DELETE CASCADE
/

ALTER TABLE STGAJK.USERB
ADD CONSTRAINT K_USERB
PRIMARY KEY (USERID)
USING INDEX PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE TBS
STORAGE(INITIAL 16K
NEXT 16K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
LOGGING
/

CREATE TABLE SCOTT.EMP
(
EMPNO NUMBER(4,0) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4,0),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2,0),
CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO) REFERENCES SCOTT.DEPT (DEPTNO),
CONSTRAINT PK_EMP PRIMARY KEY (EMPNO)
)
/

-- Create table
create table T_PXRS
(
XMBH CHAR(20) not null,
JGBH CHAR(15) not null,
XQRS NUMBER,
SZDWBH CHAR(15)
)
tablespace USERS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents 4096
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table T_PXRS
add primary key (XMBH,JGBH)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents 4096
pctincrease 0
);
-- Create/Recreate indexes
create index XIF39T_PXRS on T_PXRS (JGBH)
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents 4096
pctincrease 0
);
create index XIF9T_PXRS on T_PXRS (XMBH)
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents 4096
pctincrease 0
);