title: Oracle SQL: How to replace within all members of a list
body: <p>Using Oracle SQL...</p>
  <p>I'd like to use the <code>replace</code> function on all values of a hardcoded list. Something like this...</p>
  <pre><code>WHERE (
      (field IN replace(('PREFIX-ITEM0','PREFIX-ITEM1','PREFIX-ITEM2','PREFIX-ITEM3','PREFIX-ITEM4','PREFIX-ITEM5','PREFIX-ITEM6','PREFIX-ITEM7','PREFIX-ITEM8','PREFIX-ITEM9'),'PREFIX-','NEWBIE-'))
  )
  </code></pre>
  <p>Is there any way to do this?</p>