Simple Select Qry

[saravanankm]

Hi

I have one table That Contains 5 Records.
i Need to select first column to Print column Format...

For Example

table : Student
Fields are
1. Roll No
2. Student Name
3. Subject
4. Mark

data Stored like this
Roll No Name Subject Mark
---------------------------------------------------------------
101 Ram English 78
101 Ram Maths 98
101 Ram Computer 95
102 Captain Maths 100
102 Captain Computer 99

but I want to select Like this

Roll No Name English Maths Computer
----------------------------------------------------------------------------------------------
101 Ram 78 98 95
102 Captain --- 100 99

pls Reply Soon Any One

With Regards
Captain

[arg]

I know this is rather late, but this can be done with out views etc.
Check out http://www.oracle.com/technology/oramag/code/tips2005/062005.html

I do not see a way to dynamicaly create column titles from rows without multiple views, functions, or procedures.

[saravanankm]

Hi

Thanks!!!

With Regards,
Captain