title: defining a unique key column in apex
body: <p>I am trying to get the distinct records from a table, as many duplicate rows are coming from the following query</p>
  
  <pre><code>select * from sales_details_view;
  </code></pre>
  
  <p>When I query the following query in pl/sql developer, I am getting correct results</p>
  
  <pre><code>select distinct * from sales_details_view;
  </code></pre>
  
  <p>But when I use the same query in an interactive report in Oracle APEX 4.1, it is giving me the following error</p>
  
  <blockquote>
    <p>The report query needs a unique key to identify each row. The supplied
    key cannot be used for this query. Please edit the report attributes
    to define a unique key column. ORA-01446: cannot select ROWID from, or
    sample, a view with DISTINCT, GROUP BY, etc.</p>
  </blockquote>