Oracle - Order by specific values first, then the rest
<p>I've got an Oracle 11g table with a column indicating statuses for a number of items. Is there any way to do a select where three specific flags are ordered first, and then the rest in alphabetical order? </p>

<p>Something similar to </p>

<pre><code>SELECT ITEM, STATUS FROM FOO ORDER BY STATUS ('I', 'U', 'P') ASC
</code></pre>

<p>which would then list all items with status I, then U, then P, and then the remaining items last.</p>