SQL> SQL> create table e_id 2 ( 3 cid number not null, 4 maxid number not null, 5 constraint pk_e_id primary key (cid) 6 );Table createdExecuted in 0.125 secondsSQL> create index idx_id_all On e_id(cid, maxid);Index createdExecuted in 0.032 secondsSQL>
(
cid number not null,
maxid number not null,
constraint pk_e_id primary key (cid)
);
/
create index idx_id_all On e_id(cid, maxid);
你那个SQL中有了;后再来一个/表示再执行上面的SQL,就是说create table语句会被执行两次。
看错了 :p
SQL> create table e_id
2 (
3 cid number not null,
4 maxid number not null,
5 constraint pk_e_id primary key (cid)
6 );Table createdExecuted in 0.125 secondsSQL> create index idx_id_all On e_id(cid, maxid);Index createdExecuted in 0.032 secondsSQL>