i use oracle as my database and
i have a table like this
ID TAG MIN AVG MAX
---------------------------------------
1101 Brite 12 15 16
1101 Dirt 2 4 7
how to make a view from table above,with the structure like this
ID BriteMin BriteAvg BriteMax DirtMin DirtAvg DirtMax
-------------------------------------------------------------------------
1101 12 15 16 2 4 7
plz reply me a.s.a.p plz....
i have a table like this
ID TAG MIN AVG MAX
---------------------------------------
1101 Brite 12 15 16
1101 Dirt 2 4 7
how to make a view from table above,with the structure like this
ID BriteMin BriteAvg BriteMax DirtMin DirtAvg DirtMax
-------------------------------------------------------------------------
1101 12 15 16 2 4 7
plz reply me a.s.a.p plz....