Hi gurus,

Can i make my rows as the columns in a oracle database.
eg:
i have a table for marks scored by students

name sub1 sub2
---- ---- ----
a 50 60
b 70 90
c 65 85

i need a report with the names as my column heading
with some avg marks of each one as

a b c
-- --- ---
55 80 75

is it possible? in which version?
if yes how?

thanks
Subin

Oracle LazyDBA home page