DROP TABLE ems_details;

CREATE TABLE ems_details(
	ems_number	number(10)		not null,
	ems_date	varchar2(50)		not null,
	badge		number(10)		not null,
	ambo		varchar2(10)		not null,
	hosp		varchar2(10)		not null,
	CONSTRAINT cons_ems_number PRIMARY KEY (ems_number) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;