列名多行显示

Question

比如我现在做个查询  select department_name as "DEPARTMENT NAME" from departments显示的效果是     |  DEPARTMENT NAME |
                 |  AA              |
                 |  BB              |而我希望列名多行显示      |  DEPARTMENT      |
                          |  NAME            |                          |  AA              |
                          |  BB              |请问，在SQL语句中要怎么写？

Answer 1

select deptno as department,deptno as name from emp
不能拆开吧

Answer 2

select department_name as "DEPARTMENT" from departments
union 
select 'NAME'as "DEPARTMENT" from dual

Answer 3

SQL> select deptno "deptno
  2   no",ename,empno from emp
  3  ;
 
deptno
 no        ENAME      EMPNO
---------- ---------- -----
        20 SMITH       7369
        30 ALLEN       7499
        30 WARD        7521
        20 JONES       7566
        30 MARTIN      7654
        30 BLAKE       7698
        10 CLARK       7782
        20 SCOTT       7788
        10 KING        7839
        30 TURNER      7844
        20 ADAMS       7876
        30 JAMES       7900
        20 FORD        7902
        10 MILLER      7934
 
14 rows selected
 
SQL> 

Answer 4

--列名显示的时候敲回车键 加双引号 出来特殊的列名显示
select department_name as "DEPARTMENT 
NAME" from departmentsSQL> select id "i
  2  d",name from tt
  3  /i
d        NAME
---------- --------------------
wkc168
2
2
2
2
2
8
test
168        wkc168
128        wkc128
18         wkc18i
d        NAME
---------- --------------------
11
22
44已选择14行。