地区码

/*
开户省份，
开户区，
开户城市，
开户行，
身份证，
名字，
手机号码，
户口所在地，
消费额，
性别，
年龄
*/
-- Create table
create table mobile
(
province varchar2(10),
city varchar2(20),
section varchar2(20),
openplace varchar2(60),
IDNumber varchar2(20),
name varchar2(12),
mobile varchar2(12),
balance varchar2(20),
sex varchar2(1),
age number,
address varchar2(100)
)
partition by list (city)
(
partition p0731 values (0731),
partition p0732 values (0732)

)
tablespace SYSTEM
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column mobile.province
is '开户省份';
comment on column mobile.city
is '开户区';
comment on column mobile.section
is '开户城市';
comment on column mobile.openplace
is '开户行';
comment on column mobile.IDNumber
is '身份证';
comment on column mobile.name
is '名字';
comment on column mobile.mobile
is '手机号码';
comment on column mobile.balance
is '消费额';
comment on column mobile.sex
is '性别';
comment on column mobile.age
is '年龄';
comment on column mobile.address
is '户口所在地';