Home » Other » Training & Certification » plz solve this query
plz solve this query [message #282051] Tue, 20 November 2007 12:18 Go to next message
sunilcse1
Messages: 23
Registered: June 2007
Location: Bangalore
Junior Member
Hi all

Please solve the query

My table is like this forma

col1 col2 col3
1 2 3
4 5 6

I want the output like

col1 1 4
col2 2 5
col3 3 6
Re: plz solve this query [message #282052 is a reply to message #282051] Tue, 20 November 2007 12:20 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please work a little bit.
For instance, search for pivot.
This is a classical homework.

Regards
Michel
Previous Topic: DBA
Next Topic: oracle discoverer
Goto Forum:
  


Current Time: Thu Apr 25 03:45:05 CDT 2024