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