Divide a delimited line into multiple lines
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
