How to select and print data horizontally.

If i have a student table, and I do:

sql> 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

If you want to have an easy way to transpose your data (see rows as columns and columns as rows) you can use the SQL*XL addin in Excel. It can fetch the database data directly into a spreadsheet and transpose it for you.

Have a look at SQL*XL at www.oraxcel.com

Gerrit-Jan Linker
www.oraxcel.com (SQL*XL)