select /*+ qb_name(outer) leading(b@inner) use_nl(a@outer)*/
*
from emp a
where deptno in (select /*+ qb_name(innner) */
deptno
from dept b where dname='ACCOUNTING')
select /*+ qb_name(outer) leading(b@inner) use_nl(a@outer)*/
*
from emp a
where deptno in (select /*+ qb_name(innner) */
deptno
from dept b where dname='ACCOUNTING')