oracle alias in where clause

Question

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?

Please expand your question with some details. Show us the sort of query you're talking about, and how you want to use this variable in another query. — APC, Jul 14 '10 at 06:01

heisenberg · Accepted Answer · 2010-07-14T06:15:30.847

0

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

edited Jul 14 '10 at 06:15

answered Jul 14 '10 at 05:42

heisenberg

1 Answers1