matrix query - problem

[madhugp]

is it possible to write a matrix query using select
statement.

e.g to display job titles as horizonal rows, deptnos as vertical
columns and total salary as cells from emp table.


10 20 30

clerk 6000 40000 9000

officer 30000 24000 7000

[gandolf989]

is it possible to write a matrix query using select
statement.

e.g to display job titles as horizonal rows, deptnos as vertical
columns and total salary as cells from emp table.


10 20 30

clerk 6000 40000 9000

officer 30000 24000 7000

Are you talking about a pivot query??? If you are take a look at this asktom post, pivot query