title: How to count unique rows in Oracle
body: <p>I have an oracle database table with a lot of columns. I'd like to count the number of fully unique rows. The only thing I could find is:</p>
  
  <pre><code>SELECT COUNT(DISTINCT col_name) FROM table;
  </code></pre>
  
  <p>This however would require me listing all the columns and I haven't been able to come up with syntax that will do that for me. I'm guessing the reason for that is that this query would be very low performance? Is there a recommended way of doing this?</p>