title: Does Oracle have any equivalent function for mysql "FIELD"
body: <p>This is my MySQL query. How can I run this query in Oracle? Right now it's not working. </p>
  
  <pre><code>SELECT * FROM mytable WHERE id IN (1,2,3,4) ORDER BY FIELD(id,3,2,1,4);
  </code></pre>