qq_38035199的博客

Pipette取色器

目录 第 1 章 结构化查询语言 DM_SQL 简介 ....................................................................1 1.1 DM_SQL 语言的特点 .....................................................................................................1 1.2 保留字与标识符 ............................................................................................................2 1.3 DM_SQL 语言的功能及语句 .........................................................................................2 1.4 DM_SQL 所支持的数据类型 .........................................................................................3 1.4.1 常规数据类型 ....................................................................................................3 1.4.2 位串数据类型 ....................................................................................................5 1.4.3 日期时间数据类型 ............................................................................................6 1.4.4 多媒体数据类型 ..............................................................................................10 1.5 DM_SQL 语言支持的表达式 .......................................................................................10 1.5.1 数值表达式 ......................................................................................................11 1.5.2 字符串表达式 ..................................................................................................13 1.5.3 时间值表达式 ..................................................................................................13 1.5.4 时间间隔值表达式 ..........................................................................................15 1.5.5 运算符的优先级 ..............................................................................................16 1.6 DM_SQL 语言支持的数据库模式 ...............................................................................17 第 2 章 手册中的示例说明 ......................................................................................18 2.1 示例库说明 ..................................................................................................................18 2.2 参考脚本 ......................................................................................................................26 2.2.1 创建示例库 ......................................................................................................26 2.2.2 创建模式及表 ..................................................................................................26 2.2.3 插入数据 ..........................................................................................................33 第 3 章 数据定义语句 ..............................................................................................50 3.1 数据库修改语句 ..........................................................................................................50 3.2 管理用户 ......................................................................................................................53 3.2.1 用户定义语句 ..................................................................................................53 3.2.2 修改用户语句 ..................................................................................................59 3.2.3 用户删除语句 ..................................................................................................62 3.3 管理模式 ......................................................................................................................63 3.3.1 模式定义语句 ..................................................................................................63 3.3.2 设置当前模式语句 ..........................................................................................65 3.3.3 模式删除语句 ..................................................................................................65 3.4 管理表空间 ..................................................................................................................66 3.4.1 表空间定义语句 ..............................................................................................66 3.4.2 修改表空间语句 ..............................................................................................67 3.4.3 表空间删除语句 ..............................................................................................69 3.4.4 表空间失效文件检查 ......................................................................................70 3.4.5 表空间失效文件恢复准备 ..............................................................................70 I 目录 3.4.6 表空间失效文件恢复 ......................................................................................70 3.5 管理 HTS 表空间 .........................................................................................................71 3.5.1 创建 HTS 表空间 .............................................................................................71 3.5.2 修改 HTS 表空间 .............................................................................................71 3.5.3 删除 HTS 表空间 .............................................................................................72 3.6 管理表 ..........................................................................................................................72 3.6.1 表定义语句 ......................................................................................................72 3.6.2 表修改语句 ....................................................................................................115 3.6.3 基表删除语句 .............................................................................................133 3.6.4 基表数据删除语句 ........................................................................................134 3.6.5 事务型 HUGE 表数据重整 ............................................................................134 3.7 管理索引 ....................................................................................................................135 3.7.1 索引定义语句 ................................................................................................135 3.7.2 索引修改语句 ................................................................................................140 3.7.3 索引删除语句 ................................................................................................142 3.8 管理位图连接索引 .....................................................................................................143 3.8.1 位图连接索引定义语句 ................................................................................143 3.8.2 位图连接索引删除语句 ................................................................................145 3.9 管理全文索引 ............................................................................................................145 3.9.1 全文索引定义语句 ........................................................................................145 3.9.2 全文索引修改语句 ........................................................................................146 3.9.3 全文索引删除语句 ........................................................................................147 3.10 管理空间索引 ..........................................................................................................148 3.11 管理数组索引 ..........................................................................................................148 3.11.1 数组索引定义语句 .....................................................................................149 3.11.2 数组索引修改语句 .....................................................................................149 3.11.3 数组索引使用 .............................................................................................149 3.11.4 数组索引删除语句 .....................................................................................151 3.12 管理序列 ..................................................................................................................151 3.12.1 序列定义语句 .............................................................................................151 3.12.2 序列修改语句 .............................................................................................154 3.12.3 序列删除语句 .............................................................................................156 3.13 管理 SQL 域 .............................................................................................................156 3.13.1 创建 DOMAIN...............................................................................................156 3.13.2 使用 DOMAIN...............................................................................................157 3.13.3 删除 DOMAIN...............................................................................................158 3.14 管理上下文 ..............................................................................................................158 3.14.1 创建上下文 ..................................................................................................158 3.14.2 删除上下文 ..................................................................................................160 3.15 管理目录 ..................................................................................................................161 3.15.1 创建目录 ......................................................................................................161 3.15.2 删除目录 ......................................................................................................161 3.16 设置当前会话 ..........................................................................................................162 3.16.1 时区信息 ......................................................................................................162 II 目录 3.16.2 日期串语言 ..................................................................................................162 3.16.3 日期串格式 ..................................................................................................163 3.17 注释语句 ..................................................................................................................163 3.18 设置 INI 参数 .........................................................................................................164 3.18.1 设置参数值 ..................................................................................................164 3.18.2 设置仅对当前会话起作用 ..........................................................................165 3.19 修改系统语句 ..........................................................................................................166 3.20 设置列、索引生成统计信息 ..................................................................................166 第 4 章 数据查询语句 ............................................................................................168 4.1 单表查询 ....................................................................................................................179 4.1.1 简单查询 ........................................................................................................179 4.1.2 带条件查询 ....................................................................................................180 4.1.3 集函数 ............................................................................................................183 4.1.4 分析函数 ........................................................................................................188 4.1.5 情况表达式 ....................................................................................................205 4.2 连接查询 ....................................................................................................................209 4.2.1 交叉连接 ........................................................................................................209 4.2.2 自然连接(NATURAL JOIN)......................................................................210 4.2.3 JOIN … USING............................................................................................210 4.2.4 JOIN…ON .......................................................................................................211 4.2.5 自连接 ............................................................................................................211 4.2.6 内连接(INNER JOIN)................................................................................212 4.2.7 外连接(OUTER JOIN)................................................................................213 4.3 子查询 ........................................................................................................................217 4.3.1 标量子查询 ....................................................................................................217 4.3.2 表子查询 ........................................................................................................218 4.3.3 派生表子查询 ................................................................................................221 4.3.4 定量比较 ........................................................................................................221 4.3.5 带 EXISTS 谓词的子查询 ...........................................................................222 4.3.6 多列表子查询 ................................................................................................223 4.4 WITH 子句 ................................................................................................................224 4.4.1 WITH FUNCTION 子句 ...............................................................................224 4.4.2 公用表表达式子句 ........................................................................................225 4.5 合并查询结果 .............................................................................................................227 4.6 GROUP BY 和 HAVING 子句 ....................................................................................229 4.6.1 GROUP BY 子句的使用 ...............................................................................229 4.6.2 ROLLUP 的使用 ............................................................................................230 4.6.3 CUBE 的使用 .................................................................................................231 4.6.4 GROUPING 的使用 .......................................................................................233 4.6.5 GROUPING SETS 的使用 ...........................................................................234 4.6.6 GROUPING_ID 的使用 ................................................................................235 4.6.7 GROUP_ID 的使用 .......................................................................................236 4.6.8 HAVING 子句的使用 ....................................................................................237 III 目录 4.7 ORDER BY 子句 ........................................................................................................237 4.8 FOR UPDATE 子句 ...................................................................................................238 4.9 TOP 子句 ....................................................................................................................240 4.10 LIMIT 限定条件 .....................................................................................................241 4.10.1 LIMIT 子句 ................................................................................................241 4.10.2 ROW_LIMIT 子句 ......................................................................................242 4.11 全文检索 ..................................................................................................................243 4.12 层次查询子句 ..........................................................................................................245 4.12.1 层次查询子句 .............................................................................................245 4.12.2 层次查询相关伪列 .....................................................................................246 4.12.3 层次查询相关操作符 .................................................................................246 4.12.4 层次查询相关函数 .....................................................................................246 4.12.5 层次查询层内排序 .....................................................................................246 4.12.6 层次查询的限制 .........................................................................................247 4.13 并行查询 ..................................................................................................................251 4.14 ROWNUM ....................................................................................................................252 4.15 数组查询 ..................................................................................................................253 4.16 查看执行计划与执行跟踪统计 ..... 目录 第 7 章 物化视图 ....................................................................................................283 7.1 物化视图的定义 ....................................................................................................283 7.2 物化视图的修改 ....................................................................................................286 7.3 物化视图的删除 ....................................................................................................287 7.4 物化视图的更新 ....................................................................................................288 7.5 物化视图允许的操作 ...........................................................................................288 7.6 物化视图日志的定义 ...........................................................................................288 7.7 物化视图日志的删除 ...........................................................................................290 7.8 物化视图的限制 ....................................................................................................290 7.8.1 物化视图的一般限制 ....................................................................................290 7.8.2 物化视图的分类 ............................................................................................290 7.8.3 快速刷新通用约束 ........................................................................................291 7.8.4 物化视图信息查看 ........................................................................................291 第 8 章 函数 ............................................................................................................293 8.1 数值函数 ....................................................................................................................298 8.2 字符串函数 ................................................................................................................311 8.3 日期时间函数 ............................................................................................................332 8.4 空值判断函数 ............................................................................................................351 8.5 类型转换函数 ............................................................................................................352 8.6 杂类函数 ....................................................................................................................355 第 9 章 一致性和并发性 ........................................................................................358 9.1 DM 事务相关语句 ......................................................................................................358 9.1.1 事务的开始 ....................................................................................................358 9.1.2 事务的结束 ....................................................................................................358 9.1.3 保存点相关语句 ............................................................................................359 9.1.4 设置事务隔离级及读写特性 ........................................................................360 9.2 DM 手动上锁语句 ......................................................................................................361 第 10 章 外部函数 ..................................................................................................364 10.1 C 外部函数 ..............................................................................................................364 10.1.1 生成动态库 .................................................................................................364 10.1.2 C 外部函数创建 ..........................................................................................366 10.1.3 举例说明 .....................................................................................................367 10.2 JAVA 外部函数 .......................................................................................................369 10.2.1 生成 jar 包 ................................................................................................370 10.2.2 JAVA 外部函数创建 ..................................................................................370 10.2.3 举例说明 .....................................................................................................371 10.3 AP 使用说明 ............................................................................................................372 第 11 章 包 .............................................................................................................373 11.1 创建包 ......................................................................................................................373 V 目录 11.1.1 创建包规范 .................................................................................................373 11.1.2 创建包主体 .................................................................................................374 11.2 重编译包 ..................................................................................................................376 11.3 删除包 ......................................................................................................................376 11.3.1 删除包规范 .................................................................................................376 11.3.2 删除包主体 .................................................................................................377 11.4 应用实例 ..................................................................................................................377 第 12 章 类类型 ......................................................................................................381 12.1 普通 CLASS 类型 .....................................................................................................381 12.1.1 声明类 .........................................................................................................382 12.1.2 实现类 .........................................................................................................383 12.1.3 重编译类 .....................................................................................................385 12.1.4 删除类 .........................................................................................................386 12.1.5 类的使用 .....................................................................................................386 12.2 JAVA CLASS 类型 .................................................................................................388 12.2.1 定义 JAVA 类 ..............................................................................................389 12.2.2 重编译 JAVA 类 ..........................................................................................391 12.2.3 删除 JAVA 类 ..............................................................................................391 12.2.4 类的使用 .....................................................................................................391 第 13 章自定义类型 ................................................................................................393 13.1 创建类型 ..................................................................................................................393 13.2 创建类型体 ...............................................................................................................394 13.3 重编译类型 ...............................................................................................................395 13.4 删除类型 ...................................................................................................................395 13.4.1 删除类型 ......................................................................................................396 13.4.2 删除类型体 ..................................................................................................396 13.5 自定义类型的使用 ...................................................................................................396 13.5.1 使用规则 .....................................................................................................396 13.5.2 应用实例 .....................................................................................................396 第 14 章 触发器 ......................................................................................................398 14.1 触发器的定义 ..........................................................................................................398 14.1.1 表触发器 ......................................................................................................398 14.1.2 事件触发器 ..................................................................................................408 14.1.3 时间触发器 ..................................................................................................418 14.2 触发器替换 ..............................................................................................................419 14.3 设计触发器的原则 ...................................................................................................419 14.4 触发器的删除 ..........................................................................................................420 14.5 禁止和允许触发器 ..................................................................................................420 14.6 触发器的重编 ..........................................................................................................421 14.7 触发器应用举例 ......................................................................................................421 14.7.1 使用触发器实现审计功能 .........................................................................422 VI 目录 14.7.2 使用触发器维护数据完整性 ......................................................................422 14.7.3 使用触发器保障数据安全性 ......................................................................423 14.7.4 使用触发器生成字段默认值 ......................................................................424 第 15 章 同义词 ......................................................................................................426 15.1 创建同义词 ..............................................................................................................426 15.2 删除同义词 ..............................................................................................................427 第 16 章 外部链接 ..................................................................................................429 16.1 创建外部链接 ..........................................................................................................429 16.2 删除外部链接 ..........................................................................................................433 16.3 使用外部链接 ..........................................................................................................434 第 17 章 闪回查询 ..................................................................................................435 17.1 闪回查询子句 ..........................................................................................................435 17.2 闪回版本查询 ..........................................................................................................437 17.3 闪回事务查询 ..........................................................................................................439 第 18 章 JSON.........................................................................................................440 18.1 数据类型 ...................................................................................................................440 18.1.1 string......................................................................................................440 18.1.2 number......................................................................................................441 18.1.3 true、false...........................................................................................441 18.1.4 null...........................................................................................................443 18.1.5 object......................................................................................................444 18.1.6 array ........................................................................................................444 18.2 函数 ..........................................................................................................................444 18.2.1 json_value ............................................................................................444 18.2.2 json_query ............................................................................................445 18.2.3 函数参数详解 ...........................................................................................446 18.3 使用 IS JSON/IS NOT JSON 条件 ...................................................................448 18.4 视图 ...........................................................................................................................451 18.4.1 视图使用说明 ..............................................................................................451 18.4.2 DBA_JSON_COLUMNS................................................................................451 18.4.3 USER_JSON_COLUMNS .............................................................................452 18.4.4 ALL_JSON_COLUMNS................................................................................452 18.5 一个简单的例子 .......................................................................................................452 第 19 章 高级日志 ..................................................................................................455 19.1 简介 ..........................................................................................................................455 19.2 使用须知 ..................................................................................................................455 19.3 语法 ..........................................................................................................................455 19.3.1 管理日志辅助表 .........................................................................................455 19.3.2 使用日志辅助表的规则与约束 ..................................................................456 VII 目录 19.3.3 日志辅助表结构 .........................................................................................456 19.3.4 系统过程 .....................................................................................................457 19.4 使用高级日志同步数据的原则 ..............................................................................457 19.5 应用实例 ..................................................................................................................459 19.5.1 创建不带主键的源表 .................................................................................459 19.5.2 创建带主键的源表 .....................................................................................462 附录 1 关键字和保留字 .........................................................................................465 附录 2 SQL 语法描述说明 ....................................................................................469 附录 3 系统存储过程和函数 .................................................................................472 1) INI 参数管理 ..............................................................................................................472 2) 系统信息管理 ...............................................................................................................477 3) 备份恢复管理 ...............................................................................................................491 4) 定时器管理 ...................................................................................................................521 5) 数据复制管理 ...............................................................................................................524 6) 模式对象相关信息管理 ...............................................................................................533 7) 数据守护管理 ...............................................................................................................543 8) MPP 管理 ......................................................................................................................548 9) 日志与检查点管理 .......................................................................................................551 10) 数据库重演 ................................................................................................................552 11) 统计信息 ....................................................................................................................553 12) 资源监测 ....................................................................................................................560 13) 类型别名 ....................................................................................................................570 14) 杂类函数 ....................................................................................................................572 15) 编目函数调用的系统函数 .........................................................................................583 16) BFILE.........................................................................................................................593 17) HUGE 表备份还原 ......................................................................................................593 18) 定制会话级 INI 参数 ...............................................................................................595 19) 为 SQL 指定 HINT......................................................................................................597 20) 时区设置 ....................................................................................................................599

[ { "value": "110000", "label": "北京市", "children": [ { "value": "110100", "label": "市辖区", "children": [ { "value": "110101", "label": "东城区" }, { "value": "110102", "label": "西城区" }, { "value": "110105", "label": "朝阳区" }, { "value": "110106", "label": "丰台区" }, { "value": "110107", "label": "石景山区" }, { "value": "110108", "label": "海淀区" }, { "value": "110109", "label": "门头沟区" }, { "value": "110111", "label": "房山区" }, { "value": "110112", "label": "通州区" }, { "value": "110113", "label": "顺义区" }, { "value": "110114", "label": "昌平区" }, { "value": "110115", "label": "大兴区" }, { "value": "110116", "label": "怀柔区" }, { "value": "110117", "label": "平谷区" } ] }, { "value": "110200", "label": "县", "children": [ { "value": "110228", "label": "密云县" }, { "value": "110229", "label": "延庆县" } ] } ] }, { "value": "120000", "label": "天津市", "children": [ { "value": "120100", "label": "市辖区", "children": [ { "value": "120101", "label": "和平区" }, { "value": "120102", "label": "河东区" }, { "value": "120103", "label": "河西区" }, { "value": "120104", "label": "南开区" }, { "value": "120105", "label": "河北区" }, { "value": "120106", "label": "红桥区" }, { "value": "120110", "label": "东丽区" }, { "value": "120111", "label": "西青区" }, { "value": "120112", "label": "津南区" }, { "value": "120113", "label": "北辰区" }, { "value": "120114", "label": "武清区" }, { "value": "120115", "label": "宝坻区" }, { "value": "120116", "label": "滨海新区" } ] }, { "value": "120200", "label": "县", "children": [ { "value": "120221", "label": "宁河县" }, { "value": "120223", "label": "静海县" }, { "value": "120225", "label": "蓟县" } ] } ] }, { "value": "130000", "label": "河北省", "children": [ { "value": "130100", "label": "石家庄市", "children": [ { "value": "130101", "label": "市辖区" }, { "value": "130102", "label": "长安区" }, { "value": "130104", "label": "桥西区" }, { "value": "130105", "label": "新华区" }, { "value": "130107", "label": "井陉矿区" }, { "value": "130108", "label": "裕华区" }, { "value": "130109", "label": "藁城区" }, { "value": "130110", "label": "鹿泉区" }, { "value": "130111", "label": "栾城区" }, { "value": "130121", "label": "井陉县" }, { "value": "130123", "label": "正定县" }, { "value": "130125", "label": "行唐县" }, { "value": "130126", "label": "灵寿县" }, { "value": "130127", "label": "高邑县" }, { "value": "130128", "label": "深泽县" }, { "value": "130129", "label": "赞皇县" }, { "value": "130130", "label": "无极县" }, { "value": "130131", "label": "平山县" }, { "value": "130132", "label": "元氏县" }, { "value": "130133", "label": "赵县" }, { "value": "130181", "label": "辛集市" }, { "value": "130183", "label": "晋州市" }, { "value": "130184", "label": "新乐市" } ] }, { "value": "130200", "label": "唐山市", "children": [ { "value": "130201", "label": "市辖区" }, { "value": "130202", "label": "路南区" }, { "value": "130203", "label": "路北区" }, { "value": "130204", "label": "古冶区" }, { "value": "130205", "label": "开平区" }, { "value": "130207", "label": "丰南区" }, { "value": "130208", "label": "丰润区" }, { "value": "130209", "label": "曹妃甸区" }, { "value": "130223", "label": "滦县" }, { "value": "130224", "label": "滦南县" }, { "value": "130225", "label": "乐亭县" }, { "value": "130227", "label": "迁西县" }, { "value": "130229", "label": "玉田县" }, { "value": "130281", "label": "遵化市" }, { "value": "130283", "label": "迁安市" } ] }, { "value": "130300", "label": "秦皇岛市", "children": [ { "value": "130301", "label": "市辖区" }, { "value": "130302", "label": "海港区" }, { "value": "130303", "label": "山海关区" }, { "value": "130304", "label": "北戴河区" }, { "value": "130321", "label": "青龙满族自治县" }, { "value": "130322", "label": "昌黎县" }, { "value": "130323", "label": "抚宁县" }, { "value": "130324", "label": "卢龙县" } ] }, { "value": "130400", "label": "邯郸市", "children": [ { "value": "130401", "label": "市辖区" }, { "value": "130402", "label": "邯山区" }, { "value": "130403", "label": "丛台区" }, { "value": "130404", "label": "复兴区" }, { "value": "130406", "label": "峰峰矿区" }, { "value": "130421", "label": "邯郸县" }, { "value": "130423", "label": "临漳县" }, { "value": "130424", "label": "成安县" }, { "value": "130425", "label": "大名县" }, { "value": "130426", "label": "涉县" }, { "value": "130427", "label": "磁县" }, { "value": "130428", "label": "肥乡县" }, { "value": "130429", "label": "永年县" }, { "value": "130430", "label": "邱县" }, { "value": "130431", "label": "鸡泽县" }, { "value": "130432", "label": "广平县" }, { "value": "130433", "label": "馆陶县" }, { "value": "130434", "label": "魏县" }, { "value": "130435", "label": "曲周县" }, { "value": "130481", "label": "武安市" } ] }, { "value": "130500", "label": "邢台市", "children": [ { "value": "130501", "label": "市辖区" }, { "value": "130502", "label": "桥东区" }, { "value": "130503", "label": "桥西区" }, { "value": "130521", "label": "邢台县" }, { "value": "130522", "label": "临城县" }, { "value": "130523", "label": "内丘县" }, { "value": "130524", "label": "柏乡县" }, { "value": "130525", "label": "隆尧县" }, { "value": "130526", "label": "任县" }, { "value": "130527", "label": "南和县" }, { "value": "130528", "label": "宁晋县" }, { "value": "130529", "label": "巨鹿县" }, { "value": "130530", "label": "新河县" }, { "value": "130531", "label": "广宗县" }, { "value": "130532", "label": "平乡县" }, { "value": "130533", "label": "威县" }, { "value": "130534", "label": "清河县" }, { "value": "130535", "label": "临西县" }, { "value": "130581", "label": "南宫市" }, { "value": "130582", "label": "沙河市" } ] }, { "value": "130600", "label": "保定市", "children": [ { "value": "130601", "label": "市辖区" }, { "value": "130602", "label": "新市区" }, { "value": "130603", "label": "北市区" }, { "value": "130604", "label": "南市区" }, { "value": "130621", "label": "满城县" }, { "value": "130622", "label": "清苑县" }, { "value": "130623", "label": "涞水县" }, { "value": "130624", "label": "阜平县" }, { "value": "130625", "label": "徐水县" }, { "value": "130626", "label": "定兴县" }, { "value": "130627", "label": "唐县" }, { "value": "130628", "label": "高阳县" }, { "value": "130629", "label": "容城县" }, { "value": "130630", "label": "涞源县" }, { "value": "130631", "label": "望都县" }, { "value": "130632", "label": "安新县" }, { "value": "130633", "label": "易县" }, { "value": "130634", "label": "曲阳县" }, { "value": "130635", "label": "蠡县" }, { "value": "130636", "label": "顺平县" }, { "value": "130637", "label": "博野县" }, { "value": "130638", "label": "雄县" }, { "value": "130681", "label": "涿州市" }, { "value": "130682", "label": "定州市" }, { "value": "130683", "label": "安国市" }, { "value": "130684", "label": "高碑店市" } ] }, { "value": "130700", "label": "张家口市", "children": [ { "value": "130701", "label": "市辖区" }, { "value": "130702", "label": "桥东区" }, { "value": "130703", "label": "桥西区" }, { "value": "130705", "label": "宣化区" }, { "value": "130706", "label": "下花园区" }, { "value": "130721", "label": "宣化县" }, { "value": "130722", "label": "张北县" }, { "value": "130723", "label": "康保县" }, { "value": "130724", "label": "沽源县" }, { "value": "130725", "label": "尚义县" }, { "value": "130726", "label": "蔚县" }, { "value": "130727", "label": "阳原县" }, { "value": "130728", "label": "怀安县" }, { "value": "130729", "label": "万全县" }, { "value": "130730", "label": "怀来县" }, { "value": "130731", "label": "涿鹿县" }, { "value": "130732", "label": "赤城县" }, { "value": "130733", "label": "崇礼县" } ] }, { "value": "130800", "label": "承德市", "children": [ { "value": "130801", "label": "市辖区" }, { "value": "130802", "label": "双桥区" }, { "value": "130803", "label": "双滦区" }, { "value": "130804", "label": "鹰手营子矿区" }, { "value": "130821", "label": "承德县" }, { "value": "130822", "label": "兴隆县" }, { "value": "130823", "label": "平泉县" }, { "value": "130824", "label": "滦平县" }, { "value": "130825", "label": "隆化县" }, { "value": "130826", "label": "丰宁满族自治县" }, { "value": "130827", "label": "宽城满族自治县" }, { "value": "130828", "label": "围场满族蒙古族自治县" } ] }, { "value": "130900", "label": "沧州市", "children": [ { "value": "130901", "label": "市辖区" }, { "value": "130902", "label": "新华区" }, { "value": "130903", "label": "运河区" }, { "value": "130921", "label": "沧县" }, { "value": "130922", "label": "青县" }, { "value": "130923", "label": "东光县" }, { "value": "130924", "label": "海兴县" }, { "value": "130925", "label": "盐山县" }, { "value": "130926", "label": "肃宁县" }, { "value": "130927", "label": "南皮县" }, { "value": "130928", "label": "吴桥县" }, { "value": "130929", "label": "献县" }, { "value": "130930", "label": "孟村回族自治县" }, { "value": "130981", "label": "泊头市" }, { "value": "130982", "label": "任丘市" }, { "value": "130983", "label": "黄骅市" }, { "value": "130984", "label": "河间市" } ] }, { "value": "131000", "label": "廊坊市", "children": [ { "value": "131001", "label": "市辖区" }, { "value": "131002", "label": "安次区" }, { "value": "131003", "label": "广阳区" }, { "value": "131022", "label": "固安县" }, { "value": "131023", "label": "永清县" }, { "value": "131024", "label": "香河县" }, { "value": "131025", "label": "大城县" }, { "value": "131026", "label": "文安县" }, { "value": "131028", "label": "大厂回族自治县" }, { "value": "131081", "label": "霸州市" }, { "value": "131082", "label": "三河市" } ] }, { "value": "131100", "label": "衡水市", "children": [ { "value": "131101", "label": "市辖区" }, { "value": "131102", "label": "桃城区" }, { "value": "131121", "label": "枣强县" }, { "value": "131122", "label": "武邑县" }, { "value": "131123", "label": "武强县" }, { "value": "131124", "label": "饶阳县" }, { "value": "131125", "label": "安平县" }, { "value": "131126", "label": "故城县" }, { "value": "131127", "label": "景县" }, { "value": "131128", "label": "阜城县" }, { "value": "131181", "label": "冀州市" }, { "value": "131182", "label": "深州市" } ] } ] }, { "value": "140000", "label": "山西省", "children": [ { "value": "140100", "label": "太原市", "children": [ { "value": "140101", "label": "市辖区" }, { "value": "140105", "label": "小店区" }, { "value": "140106", "label": "迎泽区" }, { "value": "140107", "label": "杏花岭区" }, { "value": "140108", "label": "尖草坪区" }, { "value": "140109", "label": "万柏林区" }, { "value": "140110", "label": "晋源区" }, { "value": "140121", "label": "清徐县" }, { "value": "140122", "label": "阳曲县" }, { "value": "140123", "label": "娄烦县" }, { "value": "140181", "label": "古交市" } ] }, { "value": "140200", "label": "大同市", "children": [ { "value": "140201", "label": "市辖区" }, { "value": "140202", "label": "城区" }, { "value": "140203", "label": "矿区" }, { "value": "140211", "label": "南郊区" }, { "value": "140212", "label": "新荣区" }, { "value": "140221", "label": "阳高县" }, { "value": "140222", "label": "天镇县" }, { "value": "140223", "label": "广灵县" }, { "value": "140224", "label": "灵丘县" }, { "value": "140225", "label": "浑源县" }, { "value": "140226", "label": "左云县" }, { "value": "140227", "label": "大同县" } ] }, { "value": "140300", "label": "阳泉市", "children": [ { "value": "140301", "label": "市辖区" }, { "value": "140302", "label": "城区" }, { "value": "140303", "label": "矿区" }, { "value": "140311", "label": "郊区" }, { "value": "140321", "label": "平定县" }, { "value": "140322", "label": "盂县" } ] }, { "value": "140400", "label": "长治市", "children": [ { "value": "140401", "label": "市辖区" }, { "value": "140402", "label": "城区" }, { "value": "140411", "label": "郊区" }, { "value": "140421", "label": "长治县" }, { "value": "140423", "label": "襄垣县" }, { "value": "140424", "label": "屯留县" }, { "value": "140425", "label": "平顺县" }, { "value": "140426", "label": "黎城县" }, { "value": "140427", "label": "壶关县" }, { "value": "140428", "label": "长子县" }, { "value": "140429", "label": "武乡县" }, { "value": "140430", "label": "沁县" }, { "value": "140431", "label": "沁源县" }, { "value": "140481", "label": "潞城市" } ] }, { "value": "140500", "label": "晋城市", "children": [ { "value": "140501", "label": "市辖区" }, { "value": "140502", "label": "城区" }, { "value": "140521", "label": "沁水县" }, { "value": "140522", "label": "阳城县" }, { "value": "140524", "label": "陵川县" }, { "value": "140525", "label": "泽州县" }, { "value": "140581", "label": "高平市" } ] }, { "value": "140600", "label": "朔州市", "children": [ { "value": "140601", "label": "市辖区" }, { "value": "140602", "label": "朔城区" }, { "value": "140603", "label": "平鲁区" }, { "value": "140621", "label": "山阴县" }, { "value": "140622", "label": "应县" }, { "value": "140623", "label": "右玉县" }, { "value": "140624", "label": "怀仁县" } ] }, { "value": "140700", "label": "晋中市", "children": [ { "value": "140701", "label": "市辖区" }, { "value": "140702", "label": "榆次区" }, { "value": "140721", "label": "榆社县" }, { "value": "140722", "label": "左权县" }, { "value": "140723", "label": "和顺县" }, { "value": "140724", "label": "昔阳县" }, { "value": "140725", "label": "寿阳县" }, { "value": "140726", "label": "太谷县" }, { "value": "140727", "label": "祁县" }, { "value": "140728", "label": "平遥县" }, { "value": "140729", "label": "灵石县" }, { "value": "140781", "label": "介休市" } ] }, { "value": "140800", "label": "运城市", "children": [ { "value": "140801", "label": "市辖区" }, { "value": "140802", "label": "盐湖区" }, { "value": "140821", "label": "临猗县" }, { "value": "140822", "label": "万荣县" }, { "value": "140823", "label": "闻喜县" }, { "value": "140824", "label": "稷山县" }, { "value": "140825", "label": "新绛县" }, { "value": "140826", "label": "绛县" }, { "value": "140827", "label": "垣曲县" }, { "value": "140828", "label": "夏县" }, { "value": "140829", "label": "平陆县" }, { "value": "140830", "label": "芮城县" }, { "value": "140881", "label": "永济市" }, { "value": "140882", "label": "河津市" } ] }, { "value": "140900", "label": "忻州市", "children": [ { "value": "140901", "label": "市辖区" }, { "value": "140902", "label": "忻府区" }, { "value": "140921", "label": "定襄县" }, { "value": "140922", "label": "五台县" }, { "value": "140923", "label": "代县" }, { "value": "140924", "label": "繁峙县" }, { "value": "140925", "label": "宁武县" }, { "value": "140926", "label": "静乐县" }, { "value": "140927", "label": "神池县" }, { "value": "140928", "label": "五寨县" }, { "value": "140929", "label": "岢岚县" }, { "value": "140930", "label": "河曲县" }, { "value": "140931", "label": "保德县" }, { "value": "140932", "label": "偏关县" }, { "value": "140981", "label": "原平市" } ] }, { "value": "141000", "label": "临汾市", "children": [ { "value": "141001", "label": "市辖区" }, { "value": "141002", "label": "尧都区" }, { "value": "141021", "label": "曲沃县" }, { "value": "141022", "label": "翼城县" }, { "value": "141023", "label": "襄汾县" }, { "value": "141024", "label": "洪洞县" }, { "value": "141025", "label": "古县" }, { "value": "141026", "label": "安泽县" }, { "value": "141027", "label": "浮山县" }, { "value": "141028", "label": "吉县" }, { "value": "141029", "label": "乡宁县" }, { "value": "141030", "label": "大宁县" }, { "value": "141031", "label": "隰县" }, { "value": "141032", "label": "永和县" }, { "value": "141033", "label": "蒲县" }, { "value": "141034", "label": "汾西县" }, { "value": "141081", "label": "侯马市" }, { "value": "141082", "label": "霍州市" } ] }, { "value": "141100", "label": "吕梁市", "children": [ { "value": "141101", "label": "市辖区" }, { "value": "141102", "label": "离石区" }, { "value": "141121", "label": "文水县" }, { "value": "141122", "label": "交城县" }, { "value": "141123", "label": "兴县" }, { "value": "141124", "label": "临县" }, { "value": "141125", "label": "柳林县" }, { "value": "141126", "label": "石楼县" }, { "value": "141127", "label": "岚县" }, { "value": "141128", "label": "方山县" }, { "value": "141129", "label": "中阳县" }, { "value": "141130", "label": "交口县" }, { "value": "141181", "label": "孝义市" }, { "value": "141182", "label": "汾阳市" } ] } ] }, { "value": "150000", "label": "内蒙古自治区", "children": [ { "value": "150100", "label": "呼和浩特市", "children": [ { "value": "150101", "label": "市辖区" }, { "value": "150102", "label": "新城区" }, { "value": "150103", "label": "回民区" }, { "value": "150104", "label": "玉泉区" }, { "value": "150105", "label": "赛罕区" }, { "value": "150121", "label": "土默特左旗" }, { "value": "150122", "label": "托克托县" }, { "value": "150123", "label": "和林格尔县" }, { "value": "150124", "label": "清水河县" }, { "value": "150125", "label": "武川县" } ] }, { "value": "150200", "label": "包头市", "children": [ { "value": "150201", "label": "市辖区" }, { "value": "150202", "label": "东河区" }, { "value": "150203", "label": "昆都仑区" }, { "value": "150204", "label": "青山区" }, { "value": "150205", "label": "石拐区" }, { "value": "150206", "label": "白云鄂博矿区" }, { "value": "150207", "label": "九原区" }, { "value": "150221", "label": "土默特右旗" }, { "value": "150222", "label": "固阳县" }, { "value": "150223", "label": "达尔罕茂明安联合旗" } ] }, { "value": "150300", "label": "乌海市", "children": [ { "value": "150301", "label": "市辖区" }, { "value": "150302", "label": "海勃湾区" }, { "value": "150303", "label": "海南区" }, { "value": "150304", "label": "乌达区" } ] }, { "value": "150400", "label": "赤峰市", "children": [ { "value": "150401", "label": "市辖区" }, { "value": "150402", "label": "红山区" }, { "value": "150403", "label": "元宝山区" }, { "value": "150404", "label": "松山区" }, { "value": "150421", "label": "阿鲁科尔沁旗" }, { "value": "150422", "label": "巴林左旗" }, { "value": "150423", "label": "巴林右旗" }, { "value": "150424", "label": "林西县" }, { "value": "150425", "label": "克什克腾旗" }, { "value": "150426", "label": "翁牛特旗" }, { "value": "150428", "label": "喀喇沁旗" }, { "value": "150429", "label": "宁城县" }, { "value": "150430", "label": "敖汉旗" } ] }, { "value": "150500", "label": "通辽市", "children": [ { "value": "150501", "label": "市辖区" }, { "value": "150502", "label": "科尔沁区" }, { "value": "150521", "label": "科尔沁左翼中旗" }, { "value": "150522", "label": "科尔沁左翼后旗" }, { "value": "150523", "label": "开鲁县" }, { "value": "150524", "label": "库伦旗" }, { "value": "150525", "label": "奈曼旗" }, { "value": "150526", "label": "扎鲁特旗" }, { "value": "150581", "label": "霍林郭勒市" } ] }, { "value": "150600", "label": "鄂尔多斯市", "children": [ { "value": "150601", "label": "市辖区" }, { "value": "150602", "label": "东胜区" }, { "value": "150621", "label": "达拉特旗" }, { "value": "150622", "label": "准格尔旗" }, { "value": "150623", "label": "鄂托克前旗" }, { "value": "150624", "label": "鄂托克旗" }, { "value": "150625", "label": "杭锦旗" }, { "value": "150626", "label": "乌审旗" }, { "value": "150627", "label": "伊金霍洛旗" } ] }, { "value": "150700", "label": "呼伦贝尔市", "children": [ { "value": "150701", "label": "市辖区" }, { "value": "150702", "label": "海拉尔区" }, { "value": "150703", "label": "扎赉诺尔区" }, { "value": "150721", "label": "阿荣旗" }, { "value": "150722", "label": "莫力达瓦达斡尔族自治旗" }, { "value": "150723", "label": "鄂伦春自治旗" }, { "value": "150724", "label": "鄂温克族自治旗" }, { "value": "150725", "label": "陈巴尔虎旗" }, { "value": "150726", "label": "新巴尔虎左旗" }, { "value": "150727", "label": "新巴尔虎右旗" }, { "value": "150781", "label": "满洲里市" }, { "value": "150782", "label": "牙克石市" }, { "value": "150783", "label": "扎兰屯市" }, { "value": "150784", "label": "额尔古纳市" }, { "value": "150785", "label": "根河市" } ] }, { "value": "150800", "label": "巴彦淖尔市", "children": [ { "value": "150801", "label": "市辖区" }, { "value": "150802", "label": "临河区" }, { "value": "150821", "label": "五原县" }, { "value": "150822", "label": "磴口县" }, { "value": "150823", "label": "乌拉特前旗" }, { "value": "150824", "label": "乌拉特中旗" }, { "value": "150825", "label": "乌拉特后旗" }, { "value": "150826", "label": "杭锦后旗" } ] }, { "value": "150900", "label": "乌兰察布市", "children": [ { "value": "150901", "label": "市辖区" }, { "value": "150902", "label": "集宁区" }, { "value": "150921", "label": "卓资县" }, { "value": "150922", "label": "化德县" }, { "value": "150923", "label": "商都县" }, { "value": "150924", "label": "兴和县" }, { "value": "150925", "label": "凉城县" }, { "value": "150926", "label": "察哈尔右翼前旗" }, { "value": "150927", "label": "察哈尔右翼中旗" }, { "value": "150928", "label": "察哈尔右翼后旗" }, { "value": "150929", "label": "四子王旗" }, { "value": "150981", "label": "丰镇市" } ] }, { "value": "152200", "label": "兴安盟", "children": [ { "value": "152201", "label": "乌兰浩特市" }, { "value": "152202", "label": "阿尔山市" }, { "value": "152221", "label": "科尔沁右翼前旗" }, { "value": "152222", "label": "科尔沁右翼中旗" }, { "value": "152223", "label": "扎赉特旗" }, { "value": "152224", "label": "突泉县" } ] }, { "value": "152500", "label": "锡林郭勒盟", "children": [ { "value": "152501", "label": "二连浩特市" }, { "value": "152502", "label": "锡林浩特市" }, { "value": "152522", "label": "阿巴嘎旗" }, { "value": "152523", "label": "苏尼特左旗" }, { "value": "152524", "label": "苏尼

PyOpenGL-3.1.2-cp34-cp34m-win_amd64.whlPyOpenGL-3.1.2-cp34-cp34m-win_amd64.whl，python3.4

PyQt5-5.4.1-gpl-Py3.4-Qt5.4.1-x64 ，Python3.4适用Python3.4适用

decorator-4.2.1-py2.py3-none-any.whl

pandas-0.22.0-cp37-cp37m-win32.whl