Swaminathan K
asked on
Rows into Columns in Oracle
Hi Team,
Convert rows into columns
Table1
hostname parameter value
localhost cpu_count 16
localhost db_unique_name sams
localhost sga_max_size 34359738368
localhost sga_target 30064771072
localhost shared_pool_size 2147483648
I want to display as
hostname cpu_count db_unique_name sga_max_size sga_target shared_pool_size
localhost 16 sams 34359738368 30064771072 2147483648
I tried with decode does not work , because the column values are dynamic it keeps changing. Any help is really appreciated.
Convert rows into columns
Table1
hostname parameter value
localhost cpu_count 16
localhost db_unique_name sams
localhost sga_max_size 34359738368
localhost sga_target 30064771072
localhost shared_pool_size 2147483648
I want to display as
hostname cpu_count db_unique_name sga_max_size sga_target shared_pool_size
localhost 16 sams 34359738368 30064771072 2147483648
I tried with decode does not work , because the column values are dynamic it keeps changing. Any help is really appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER