create table test1(acctno varchar2(10), col1 number(5,2), col2 number(5,2), col3 number(5,2));

insert into test1 values('aaa',1,2,3);

insert into test1 values('bbb',4,5,6);

insert into test1 values('ccc',7,8,9);


select * from test1;

acctno col1 col2 col3
--------------------------------------------
aaa 1 2 3
bbb 4 5 6
ccc 7 8 9



i need to output as


aaa col1 1
col2 2
col3 3
bbb col1 4
col2 5
col3 6
ccc col1 7
col2 8
col3 9


the query should be in optimized one..?>...


Thanks