I have a column called `comment` that can contain a certain pattern as many as 5 times and I would like to return all of them. Here is the value I have in my colum: 

> 
> oijdwe wbjcwe sbr ('JOJ.TTT.ABC', test) sdfjksj dlkfjs lkf qweiuh
>  ('JOJ.TTT.123', test) oiiqwd m lskc qu i ('JOJ.TTT.452', test) ksd
>  sdfskq azx ('JOJ.TTT.ACD5', test)
> 
> 
> 

I would like to return the following values: `JOJ.TTT.ABC`, `JOJ.TTT.123`, `JOJ.TTT.452` and `JOJ.TTT.ACD5`

when using the following statement 

```
 select 
     regexp_substr(comment,'JOJ.T{3}.{4}',1,1)
     ,regexp_substr(comment,'JOJ.T{3}.{4}',1,2)
     ,regexp_substr(comment,'JOJ.T{3}.{4}',1,3)
     ,regexp_substr(comment,'JOJ.T{3}.{4}',1,4)
     ,regexp_substr(comment,'JOJ.T{3}.{4}',1,5)
 from blabla

```

it works fine if the pattern is `JOJ.TTT.XXX` but not in case there are 4 caracters after "TTT.". I know this is because of the {4} I am using. How can I get the result I want?

Thanks