title: Why won't Oracle SQL let us use aliases in conditions?
body: <p>Oracle PL/SQL won't let users to use aliases in conditions. In most cases it's very practical for me to use aliases instead of long statements. What's the reason for that? What bad would happen if we could use aliases in conditions? </p>
  
  <p>Example case: <a href="https://stackoverflow.com/questions/2235166/whats-wrong-with-this-sql-query">What&#39;s wrong with this SQL query?</a></p>