PL/SQL Challenge 每日一题：2017-3-24 动态PL/SQL块
| Provincie | Re?edin?? | Prefix telefonic | Cod po?tal |
| Beijing | Beijing | 010 | 100000 |
| Shanghai | Shanghai | 021 | 200000 |
| Tianjin | Tianjin | 022 | 300000 |
| Chongqing | Chongqing | 023 | 400000 |
| Hebei | Shijiazhuang | 0311 | 050000 |
| Shanxi | Taiyuan | 0351 | 030000 |
| Mongolia Interioar? | Huhhot | 0471 | 010000 |
| Liaoning | Shenyang | 024 | 110000 |
| Jilin | Changchun | 0431 | 130000 |
| Heilongjiang | Harbin | 0451 | 150000 |
| Jiangsu | Nanjing | 025 | 210000 |
| Zhejiang | Hangzhou | 0571 | 310000 |
| Anhui | Hefei | 0551 | 230000 |
| Fujian | Fuzhou | 0591 | 350000 |
| Jiangxi | Nanchang | 0791 | 330000 |
| Shandong | Jinan | 0531 | 250000 |
| Henan | Zhengzhou | 0371 | 450000 |
| Hubei | Wuhan | 027 | 430000 |
| Hunan | Changsha | 0731 | 410000 |
| Guangdong | Guangzhou | 020 | 510000 |
| Guangxi | Nanning | 0771 | 530000 |
| Hainan | Haikou | 0898 | 570000 |
| Sichuan | Chengdu | 028 | 610000 |
| Yunnan | Kunming | 0871 | 650000 |
| Tibet | Lhasa | 0891 | 850000 |
| Shanxi | Xi'an | 029 | 710000 |
| Gansu | Lanzhou | 0931 | 730000 |
| Ningxia | Yinchuan | 0951 | 750000 |
| Qinghai | Xining | 0971 | 810000 |
| Xinjiang | Urumqi | 0991 | 830000 |
| Guizhou | Guiyang | 0851 | 550000 |
Distribuire
