Home » SQL & PL/SQL » SQL & PL/SQL » Sql (oracle 9.1.0)
Sql [message #364506] Mon, 08 December 2008 22:29 Go to next message
Messages: 1
Registered: December 2008
Location: Mumai
Junior Member
I am new to this side
Please give the answer of the following question
while selecting the data the user wants to see the data in the inverted way that means he wants to see the columns in the place of the row and in the place of the rows he wants to see the columns only by using the Sql
the Original data is like this only
Ename Sal
Smith 1000
Blake 2000
Peter 2000
and he wants the data like this way
Ename smith Blake Peter
Sal 1000 2000 3000
Please help me
Re: Sql [message #364507 is a reply to message #364506] Mon, 08 December 2008 22:46 Go to previous message
Barbara Boehmer
Messages: 8614
Registered: November 2002
Location: California, USA
Senior Member
Previous Topic: Need Help!!! (merged 4)
Next Topic: Merge
Goto Forum:

Current Time: Fri Oct 28 00:05:19 CDT 2016

Total time taken to generate the page: 0.30177 seconds