title: Get HTML output of results of a SELECT statement
body: <p>I'm using Pl/SQL and Oracle Application Express 4.1 on Oracle Database 11g.</p>
  
  <p>I've been trying send an email including HTML output of the result of a <code>SELECT</code> statement I have. I found the <code>owa_utils.cellsprint</code> function that prints out HTML, but I'm hoping to actually get the HTML in a big varchar or clob returned from a similar function. Then I can add some more text of my own and eventually send the email with the table inside. I searched around, but couldn't find anything besides the cellsprint function.</p>
  
  <p>So what I have is this: <br>
  <code>owa_utils.cellsprint('SELECT col1, col2, col3 FROM my_table WHERE condition');</code></p>
  
  <p>But what I would ideally like is something similar to this: <br>
  <code>l_clob := some_function('SELECT col1, col2, col3 FROM mytable WHERE condition');</code></p>
  
  <p>Then I would add some more HTML to l_clob and send the email.<br>
  Is there any way to do this without writing my own function to iterate through the result set and create the table using <code>&lt;tr&gt;</code> and <code>&lt;td&gt;</code> myself?</p>