How to use 'REGEXP_SUBSTR' in oracle inside java code to build a dynamic sql query using StringBuilder?

I am building a dynamic query in my Java code using StringBuilder. I need to append a SELECT sub query with REGEXP_SUBSTR expression inside an IN clause. Below is what I did.