Oracle sql substring between two characters

Oracle sql substring between two characters This is old skool. I love regular expressions and can understand them but get into an awful lot of trouble when I try to produce them. A bit like Spanish (for me). So this is just SQL INSTR / SUBSTR / REPLACE. I'm not expecting any upvotes... ................
................