Recipe 3.1. Stacking One Rowset atop Another

	ENAME_AND_DNAME      DEPTNO
	---------------  ----------
	CLARK                    10
	KING                     10
	MILLER                   10
	----------
	ACCOUNTING               10
	RESEARCH                 20
	SALES                    30
	OPERATIONS               40



	select job, deptno from emp
	where deptno = 10
	union all
	select dname, deptno from dept

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23895263/viewspace-680980/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23895263/viewspace-680980/