Home » SQL & PL/SQL » SQL & PL/SQL » row into column
row into column [message #210227] Tue, 19 December 2006 22:40 Go to next message
gopi_ora
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
Hi,
I have a table with two columns like,

empno ename
-------- -----
11 aa
22 bb

I want output as row translated into columns as shown below

11 22
aa bb


Thanks.
Re: row into column [message #210255 is a reply to message #210227] Wed, 20 December 2006 01:06 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Search for pivot queries.

MHE
Previous Topic: DBA users
Next Topic: Inserting column
Goto Forum:
  


Current Time: Sat Dec 03 20:06:08 CST 2016

Total time taken to generate the page: 0.07014 seconds