How can I write column values horizontally ?

Please help me to get the result like

ABC   B.Sc   M.SC      Diploma
XYZ   BE     M.Tech

From the following tables.

stud                            Deg
--------------                  --------------
sl   number(2) Primary Key      sl_ref  number(2)    foreign key stud.sl
name varchar2(20)               deg_name varhcar2(2)

select * from stud;

sl name
-- ----
1 ABC
2 XYZ Select * from Deg;

sl_ref Deg_name
------ --------

1         B.Sc
1         M.Sc
1         Diploma
2         BE
2         M.Tech

Regards
Sudheer

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 05:07:36 CDT