title: Dynamically select the columns to be used in a SELECT statement
body: <p>I would love to be able to use the system tables (Oracle in this case) to drive which fields are used in a SELECT statement.  Something like:</p>
  
  <pre><code>SELECT 
  (
  select  column_name
  from    all_tab_cols
  where   table_Name='CLARITY_SER'
  AND     OWNER='CLARITY'
  AND     data_type='DATE'
  ) 
  FROM CLARITY_SER
  </code></pre>
  
  <p>This syntax doesn't work, as the subquery returns multiple rows, instead of one row with multiple columns.</p>
  
  <p>Is it possible to generate a SQL statement dynamically by querying the table schema information in order to select only certain columns?</p>
  
  <p>** edit **
  Do this without using a function or procedure, if possible.</p>