I need to output some select results "horizontal" rather than
"vertically" in sqlplus, what I mean is:
given the table:
mytable:
department value
dept1 1
dept1 2
dept1 3
dept2 4
dept2 5
dept2 6
..... ...
I want to output something like:
select xxxxxxxxxx;
dept1 1 2 3
dept2 4 5 6
..... ... ... ...
Anyone has any idea of how to do this in sqlplus?
Thanks a lot for your kind help.
PS: for your convenience, I put the sql to create the test table as
following:
create table mytest01 (department varchar2(10), value number);
insert into mytest01 values ('dept1', 1);
insert into mytest01 values ('dept1', 2);
insert into mytest01 values ('dept1', 3);
insert into mytest01 values ('dept2', 4);
insert into mytest01 values ('dept2', 5);
insert into mytest01 values ('dept2', 6);
insert into mytest01 values ('dept3', 7);
insert into mytest01 values ('dept3', 8);
insert into mytest01 values ('dept3', 9);
the result I would like is:
select xxxxxxxxxxx......;
