求在Oracle中创建表结构的语法，要有主键和外键解决方案

求在Oracle中创建表结构的语法，要有主键和外键
rt

------解决方案--------------------
create table PER_USER_LIST
(
OA_NAME VARCHAR2(30) not null,
CN_NAME VARCHAR2(30)
)
tablespace USERS;

-- Create/Recreate primary, unique and foreign key constraints
alter table PER_USER_LIST
add primary key (OA_NAME)
using index
tablespace USERS;

------解决方案--------------------
alter table TGED070_QCP
add constraint pk_TGED070_QCP primary key (I94_COD_QCP)
using index tablespace system;