title: How to shorten my Oracle Query which includes looking for data of same field?
body: <p>Is there a shorter way to write below query in Oracle:</p>
  
  <pre><code>select * from booknames where author = 'Doyle' or author ='Brown' or author = 'Martin' or author = 'Kafka';
  </code></pre>
  
  <p>I don't like the sound that I have to write field name (author) 4 times. </p>