Example Analysis of splitting multiple rows of Oracle data rows
Editor to share with you the Oracle data row split multi-row example analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!
Single line split
If the table data has only one row, you can use connect by+ regular methods directly on the original table, such as:
Select regexp_substr ('444.555.666,' [^.] +', 1, level) colfrom dualconnect by level
