将下面这个查询结果可以行转列吗?不用存储过程 Select Rownum, to_date('2010-03-28 08', 'yyyy-mm-dd hh24:mi:ss')+(Rownum-1)/24 tm
from dual connect by rownum<= ( to_date('2010-03-31 08', 'yyyy-mm-dd hh24:mi:ss')- to_date('2010-03-28 08', 'yyyy-mm-dd hh24:mi:ss') )*24+1
from dual connect by rownum<= ( to_date('2010-03-31 08', 'yyyy-mm-dd hh24:mi:ss')- to_date('2010-03-28 08', 'yyyy-mm-dd hh24:mi:ss') )*24+1
精华区,WildWave的通用行转列