oracle alias in where clause [duplicate]

This question already has answers here: Using an Alias 开发者_Go百科in a WHERE clause (5 answers) Closed 7 months ago.

I am inside oracle procedure

I have a complex query with join which gives single value to which i assign alias

now can i pass alias in where clause in another query rather than making above query again as subquery?

---

Yes, provided its in scope (ie a subquery you're joining to in the FROM clause that the WHERE exists in).