Oracle 12c - dynamically generate a where clause based on a value in a different table
<p>I am trying to write an Oracle 12c SQL statement like this:</p>

<pre><code>select * from table1 where col1 in (*dynamicvalue*)
</code></pre>

<p>I want the dynamic value to be the result of the following SQL:</p>

<pre><code>select col2 from table2 where rowid = 1
</code></pre>

<p>Is this possible? Col2 contains a list of values like this: 'val1','val2','val3'</p>

<p>Thank you</p>