title: How to use output of one jdbc request to insert data for another jdbc query
body: <p>I am using first JDBC request to fetch values of one column from my oracle DB. I am storing it an output variable 'DCN'. Now I need to insert all the data extracted from this query into my second JDBC request. I am wondering if there is a way to insert the data in one single query rather than using for each controller to loop over each of the value present in the variable 'DCN'.
  Following is the query I ma using in the second JDBC request and it's child of ForEach Controller</p>
  
  <pre><code>INSERT INTO Data (FILENET_DCN)
  VALUES ('${DCN}');
  Select @@rowcount;
  </code></pre>
  
  <p>If i try to use this query outside of ForEach controller, then instead of values, "${DCN}" (literal text) is what gets inserted into the table as it is.</p>
  
  <p>For Each Controller:</p>
  
  <p><a href="https://i.stack.imgur.com/uIYX4.png" rel="nofollow noreferrer">ForEach controller</a></p>