title: Oracle SQL Query to to run a column value as sql query
body: <p>I have the following row in the table </p>
  
  <pre><code> TEMP_ID    HTML_LABEL HTML_NAME     OPTIONS_TYPE OPTION_VALUES                   HTML_CODE
  ----------------------------------------------------------------------------------------------
      2       RULE_NO :  RULE_NO_7_32  D            SELECT DRV_COLUMN FROM FRD_DATA &lt;reconTags:renderSelect&gt;&lt;/reconTags:renderSelect&gt; 
  </code></pre>
  
  <p>I want an oracle sql query that gives the output like this</p>
  
  <pre><code>  TEMP_ID HTML_LABEL HTML_NAME      OPTIONS_TYPE OPTION_VALUES HTML_CODE
     ----------------------------------------------------------------------------                                                                     
      2      RULE_NO :  RULE_NO_7_32  D            1,2,3,4       &lt;reconTags:renderSelect&gt;&lt;/reconTags:renderSelect&gt;   
  </code></pre>
  
  <p>I want the result of the query stored in the option_values field to be displayed as the value of the option_values field. (Possibly comma-separated concatenated values, where the query would return multiple rows.) </p>