列名多行显示

[jjandkk]

比如我现在做个查询 select department_name as "DEPARTMENT NAME" from departments

显示的效果是 | DEPARTMENT NAME |
| AA |
| BB |

而我希望列名多行显示 | DEPARTMENT |
| NAME |

| AA |
| BB |

请问，在SQL语句中要怎么写？

[shijiuka]

楼上的写法果然能实现，很神奇呐。
能解释下是为什么吗？

[心中的彩虹]

[Quote=引用楼主 jjandkk 的回复:]
比如我现在做个查询 select department_name as "DEPARTMENT NAME" from departments

显示的效果是 | DEPARTMENT NAME |
| AA |
| BB |

而我希望列名多行显示 | DEPARTMENT |
| NAME |

| AA |
| BB |

请问，在SQL语句中要怎么……
[/Quote]
--列名显示的时候敲回车键 加双引号 出来特殊的列名显示
select department_name as "DEPARTMENT
NAME" from departments

SQL> 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         wkc18

i
d        NAME
---------- --------------------
11
22
44

已选择14行。

[Phoenix_99]

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

[shijiuka]

这么怪异的问题。。

[gelyon]

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

[真的不知道取什么名]

需求太奇怪了，说说你为什么会要这样的需求

[minitoy]

估计是前台报表展现,直接用语句把整个报表拼出来..

[minitoy]

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>