Oracle Build Table

CREATE TABLE T_hq_e
(
XINGM VARCHAR2 (10),
CHENGJ number is not NULL,
Jiatzz VARCHAR2 (15)
)
Tablespace SYSTEM
Pctfree 10
Pctused 40
Initrans 1
Maxtrans 255
Storage
(
Initial 16K
Minextents 1
Maxextents Unlimited
);
--ADD comments to the columns
Comment on column t_hq_e.xingm
is ' name ';
Comment on column T_hq_e.chengj
is ' performance ';
Comment on column T_hq_e.jiatzz
Is ' home address ';
--Create/recreate primary, unique and foreign KEY constraints
ALTER TABLE T_hq_e
Add constraint Pk_t_hq_jiatdz primary key (CHENGJ)
Using index
Tablespace SYSTEM
Pctfree 10
Initrans 2
Maxtrans 255
Storage
(
Initial 64K
Minextents 1
Maxextents Unlimited
);
--create/recreate CHECK constraints
ALTER TABLE T_hq_e
Add Constraint Check_chengj
Check (chengj>60 and Chengj <100);

Oracle Build Table