How to write, Oracle cutting string SQL statements request bosses to help, thank you!!!!!!-CodePudding

Ask bosses teach, small white just contact oracle, now there is a demand according to the value of caseManagerName field
, and then in the database according to the comma cutting out, li si and mellisa two data

CodePudding user response:

 
Select regexp_substr (' zhang, wang, li and zhao ', '[^,] +' 1, level) name 
The from dual 
Connect by rownum & lt;=regexp_count (' zhang, wang, li and zhao ', ', ') + 1;

CodePudding user response:

https://blog.csdn.net/kruie/article/details/82701706 to comma split the sample