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:
Select TABLEA.SomeIDNumber AS "Id",
end AS "Results"
No, you can't refer to the alias elsewhere in the same level of
select, other than in the
order by clause, because of when Oracle assigns it internally.
From the documentation (emphasis added):
You can use a column alias, c_alias, to label the immediately preceding expression in the select list so that the column is displayed with a new heading. The alias effectively renames the select list item for the duration of the query. The alias can be used in the
ORDER BYclause, but not other clauses in the query.
You would need to use an inner query, something like:
select "Id", case "Id" when 3 then 'foo' else 'bar' end AS "Results" from ( select TABLEA.SomeIDNumber AS "Id", from TABLEA );