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
swainprafullaranjan
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
like
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: 8636
Registered: November 2002
Location: California, USA
Senior Member
http://www.williamrobertson.net/documents/one-row.html
Previous Topic: Need Help!!! (merged 4)
Next Topic: Merge
Goto Forum:
  


Current Time: Sat Dec 10 01:20:46 CST 2016

Total time taken to generate the page: 0.10644 seconds