Home » SQL & PL/SQL » SQL & PL/SQL » SQL Query
SQL Query [message #223342] Thu, 08 March 2007 08:59 Go to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
Hi All,

How to convert row into coumn name.

Table_Data
0.10
0.28
1.25
3.55
4.00
5.66

OUTPUT Need
0.10 0.28 1.25 3.55 4.00

Note: about 100 records in a source table. The given table records are dynamically generated.

Please help for the same


Arvind
Re: SQL Query [message #223345 is a reply to message #223342] Thu, 08 March 2007 09:07 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Pivoting a resultset? And when you searched the board you didn't find anything? That's funny.

But here's one thread that might help you out.

MHE

[Updated on: Thu, 08 March 2007 09:09]

Report message to a moderator

Re: SQL Query [message #223539 is a reply to message #223345] Fri, 09 March 2007 06:47 Go to previous message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
But i need create a table with the help of record converts to coumn names.

Previous Topic: working with abstract data type, help
Next Topic: HOW TO SELECT NOT NULL COLUMNS FROM A TABLE
Goto Forum:
  


Current Time: Thu Dec 08 20:28:46 CST 2016

Total time taken to generate the page: 0.11008 seconds