Shulou(Shulou.com)06/01 Report--

Today, we encounter a demand that has not been done before. To divide the delimited data into multiple rows and columns into another table according to the delimiter, while the other columns remain the same, I have thought for a while that it is more difficult to associate the changed data with the one before the change. After reading the next few cases on the Internet, I feel that https://blog.csdn.net/mchdba/article/details/51946573 's method is quite good.

For example, the source data is like this

The target data is like this.

The insert statement is:

Insert into temp_0428_test2 (pro_key,nip)

With temp0 as

(select LEVEL lv from dual CONNECT BY LEVEL

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.