By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_SUBSTR('<CC>3</CC><CN>ROSSI</CN><CN>OTHERROSSI</CN><NO>MARIO</NO><IN>VIADELLEMIMOSE4</IN>','<CN>(.*)</CN>',1,1,NULL,1) |
|---|
| ROSSI</CN><CN>OTHER ROSSI |
| REGEXP_SUBSTR('<CC>3</CC><CN>ROSSI</CN><CN>OTHERROSSI</CN><NO>MARIO</NO><IN>VIADELLEMIMOSE4</IN>','<CN>(.*?)</CN>',1,1,NULL,1) |
|---|
| ROSSI |