hi friends,

create table goods(ITEM_NO number,
PRODUCT_NAME varchar2(20),
COMPANY_NAME varchar2(20));

insert into goods values(1,'TV','SONY');
insert into goods values(2,'COMPUTER','HP');

--------------------============--------------------
Generally when we select the data from a table the o/p format will be...

ITEM_NO PRODUCT_NAME COMPANY_NAME
1 TV SONY
2 COMPUTER HP

But, I want to print the the table in the below format...

ITEM_NO 1 2
PRODUCT_NAME TV COMPUTER
COMPANY_NAME SONY HP

Using oracle SQL or PL/SQL
Please, help me.