select

sum(decode(to_char(a.contractdate,'hh24'),'10',1)),

sum(decode(to_char(a.contractdate,'hh24'),'11',1)),

sum(decode(to_char(a.contractdate,'hh24'),'12',1)),

sum(decode(to_char(a.contractdate,'hh24'),'13',1)),

sum(decode(to_char(a.contractdate,'hh24'),'14',1)),

sum(decode(to_char(a.contractdate,'hh24'),'15',1)),

sum(decode(to_char(a.contractdate,'hh24'),'16',1)),

sum(decode(to_char(a.contractdate,'hh24'),'17',1)),

sum(decode(to_char(a.contractdate,'hh24'),'18',1))

from

h_hous_sell a,

h_hous_income b

가로를 세로로 출력할려고 합니다.

이부분을 어떻게 수정을 해야 할가요?