This discussion is archived
0 Replies Latest reply: Nov 15, 2012 9:36 PM by 972471 RSS

Oracle 10g Query Format

972471 Newbie
Currently Being Moderated
0

down vote
favorite I am using oracle 10g. I have a temp table TEMP.

TEMP has following structure:-

USER COUNT TYPE
1 10 T1

2 21 T2

3 45 T1

1 7 T1

I need a query which will show all types has column names,and types can be any value like T1,T2,..Tn and columns will be like:-

USER T1 T2 Tn
and User column will show all the users and T1,T2 column will show total count of types.

Edited by: 969468 on Nov 15, 2012 9:35 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points