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/，如需轉載，請註明出處，否則將追究法律責任。