When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:
select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)
query works well with 10g but 11g returns error that aliasQuery not defined
may be this syntax no longer supported in 11g or here is some database missing configurations
Thanks
Dad