Let's say I do this:

select name, class from student;

name class
---- -----
John english
John history
John math
John computer

but now i want data (class field) to print horizontally like below. how do i do it?

name class class class class
---- ------- ------- ------ --------
John english history math computer

thanks so much.

well I know no simple answer.

but if you know the different type of classes you could do a case, or you could build a table then update it.

select user,
class1 = case when class = 'ENGLISH' then class else 'NONE' end,
class2 = case when class = 'MATH' then class else 'NONE' end,
class3 = case when class = 'HISTORY' then class else 'NONE' end,
class4 = case when class = 'COMPUTER' then class else 'NONE' end
from TABLE

That is not that great of a solution, but maybe point you in a direction to get started.

you can use command like
select 1,(select class from) as firstfield,(select ....) secondfield......
from dual

it works if you have the fixed number of classes....Otherwise also you can construct through pl/sql .
Better soln would be create a table and insert the values before running the report