title: Using Alias In When Portion of a Case Statement in Oracle SQL
body: <p>I've been trying to look up for awhile now if it's possible to use an alias stated earlier in the select statement if it can be used in a case later in the case statement for Oracle SQL. Most results I find are about how to make an Alias based on a case statement which isn't the same problem. A quick example would be something like:</p>
  
  <pre><code>Select TABLEA.SomeIDNumber AS "Id",
         case ID
            when 3
            then 'foo'
            else 'bar'
         end AS "Results"
  FROM OMEGA.TABLEA
  </code></pre>
  
  <p>It's really not that simple in the SQL Statement I'm creating (it's actually created based on a previous case statement and requires some joins on various tables to do the full other pats of the query, but it wouldn't really make sense without knowing more of the database which I can't share).</p>
  
  <p>I'm just wondering if it's possible to use an alias in a case statement later in the select statement for Oracle (I know such things can be done with Access kinda "SQL"). Or is it better for me to do some reworking of the select to make it nested select statements? Probably doable, just a bit more of a pain.</p>