I have a column of data -

blah blah blah [this text 1] yada yada [that text 2] da-da-da

I want the output to be -

this text 1, that text 2

In essence, I need to capture whatever is between the brackets, and separate each bracketed expression with a comma.

The number of bracketed expressions in the column can vary from record to record, from 0 to n bracketed expressions.

I'm having trouble constructing the Pattern for REGEXPR_SUBSTR to accomplish this.

I'm thinking I'll need to use the REGEXP_SUBSTR and CONNECT BY, but not sure how.