PL/SQL (MOSC)

MOSC Banner

converting rows into columns

edited Nov 23, 2011 4:25AM in PL/SQL (MOSC) 4 comments
hi,

i wanted to convert my all the data of one table into column name.

ex.: name     dept

      -------    -------

      X           A

      Y          B

      Z          C

Desired Out put is ---

name   dept   A    B    C    X    Y    Z

------    -----  --     --   --    --    --    --

X          A

Y         B

Z          C

Required out put in SQL query.

Thanks,

Rakesh Mishra

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center