问题描述:
将以下表方式存放的数据:
1 | CMS8000290693 | ,011101251020006862, |
2 | CMS8000692449 | ,9011101012510200105,011201251020000015,041101251020000193, |
3 | CMS6000320019 | ,011101251010001452,9011101012510200100,9011301012510200100, |
4 | CMS8000695502 | ,9011001012510200009,9011101012510200102,011101251020005485, |
转换成如下方式存放:
1 | CMS8000290693 | 011101251020006862 |
2 | CMS8000692449 | 9011101012510200105 |
3 | CMS8000692449 | 011201251020000015 |
4 | CMS8000692449 | 041101251020000193 |
5 | CMS6000320019 | 011101251010001452 |
6 | CMS6000320019 | 9011101012510200100 |
7 | CMS6000320019 | 9011301012510200100 |
8 | CMS8000695502 | 9011001012510200009 |
9 | CMS8000695502 | 9011101012510200102 |
10 | CMS8000695502 | 011101251020005485 |
1、 建表语句及插入测试数据
2、 实现转换的存储过程
3、 说明
写代码过程中,用到的中间存储过程: