Home » SQL & PL/SQL » SQL & PL/SQL » display column to row (Oracle9i)
display column to row [message #437036] Wed, 30 December 2009 07:51 Go to next message
prakashaa
Messages: 31
Registered: November 2009
Location: Bangalore
Member
Hi experts ,
I hav e the following data in a table.

StudentNo
100
200
300
400
500
600
700

I want to display those values like

1st 2nd 3rd 4th 5th 6th 7th
100 200 300 400 500 600 700

Without hard coding values and also using only select statemment,because it's a production data base,i have SELECT privilige only.Please help me
Thanks in advance.



Re: display column to row [message #437043 is a reply to message #437036] Wed, 30 December 2009 08:24 Go to previous message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a standard "pivot" query. Search for this word.
By the way, what happened if you have thousand rows in your table?

Regards
Michel
Previous Topic: Oracle9i
Next Topic: All records in cursor
Goto Forum:
  


Current Time: Wed Sep 28 14:16:45 CDT 2016

Total time taken to generate the page: 0.09308 seconds