Home » RDBMS Server » Server Administration » Table Transpose
Table Transpose [message #375070] Mon, 23 July 2001 18:49 Go to next message
Vasan
Messages: 4
Registered: July 2001
Junior Member
I want to transpose a table from row to Col
original table
number
parametername
parametervalue

parameter name is a001 to a100

I want this info like
number
parmnamea001
parmnamea002
parmnamea003
parmnamea004
parmnamea005
-
-
-
-
parmnamea100
parmvalue

Thanks in Advance

Report message to a moderator

Re: Table Transpose [message #375074 is a reply to message #375070] Tue, 24 July 2001 03:25 Go to previous message
ravibabu
Messages: 12
Registered: July 2001
Junior Member
use crosstab query

Report message to a moderator

Previous Topic: Re: PL/SQL Positions in Richmond, VA and Virginia Beach
Next Topic: Order By query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 20:32:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.