我想删除所有以修改表........最后;有几个修改表........ 我的档案中的声明
create table EMPLOYEE
(
EMP_ID NUMBER not null,
D_ID NUMBER,
P_ID NUMBER,
EMP_DESC VARCHAR2(2000)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table CALL_OCCURED
add unique (HIS_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
);
create table DEPARTMENT
(
D_ID NUMBER(11) not null,
CLI VARCHAR2(45),
DNS VARCHAR2(20),
ATED_DATE DATE,
START_TIME DATE,
END_TIME DATE,
LAT VARCHAR2(45),
LON VARCHAR2(45),
MSN VARCHAR2(45),
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);