CREATE TABLE tab1
(
id INTEGER,
col2 VARCHAR2(20)
);CREATE UNIQUE INDEX SCOTT.pk1 ON SCOTT.TAB1
(ID)
LOGGING
NOPARALLEL;ALTER TABLE SCOTT.TAB1
ADD CONSTRAINT pk1
PRIMARY KEY (ID);
(
id INTEGER,
col2 VARCHAR2(20)
);CREATE UNIQUE INDEX SCOTT.pk1 ON SCOTT.TAB1
(ID)
LOGGING
NOPARALLEL;ALTER TABLE SCOTT.TAB1
ADD CONSTRAINT pk1
PRIMARY KEY (ID);
create table a
(id number(10) not null,
pw number (10) not null,
data varchar2(20),
CONSTRAINT "a" primary key (id,pw));
create table (
a varchar2(20) primary key,
b number
)简单吧~~
不过这样写的话, 主键的名字是自动生成的. 不过无所谓啦
id NUMBER,CONSTRAINT pk_id PRIMARY KEY (id),
name VARCHAR2(10)
);