title: Select List of Column Names / Aliases from Custom Sub-Query
body: <p>In Oracle, is there a way to select all the columns that are returned from a custom query with aliases? As an example, let's say we have a query as the following:</p>
  
  <pre><code>    SELECT FIRST_NAME AS COL1, LAST_NAME AS COL2, ADDRESS AS COL3
      FROM PEOPLE
  </code></pre>
  
  <p>I would like to know if an encapsulating query can be made that would return:</p>
  
  <pre><code>    COL1
      COL2
      COL3
  </code></pre>