hello
how do i change values into columns with out all the the blanks ..
i have orderunits table(orderid number,value and name are varchar2).
i tried case stmts and not getting results like below,meaning i get rows multiplied,for example in here i get total 25 rows but i should get total 15 or so
Code:
"CASE WHEN fNAME='Units' then p.value else null END AS unit_name,"
Code:
Order_ID UNIT_NAME DATE_NAME
30766600 1
30766600 090909
30766600 1
30766600 090909
any help is much appreciated
thank you
Code:
ORDER_ID VALUE NAME
30766600 090909 Date
30766600 090909 Date
30766600 090909 Date
30766600 090709 Date
30766600 090709 Date
30766600 090609 Date
30766600 090609 Date
30766600 090509 Date
30766600 090509 Date
30766600 090509 Date
30766600 090409 Date
30766600 090409 Date
30766600 090309 Date
30766600 1 Units
30766600 1 Units
30766600 1 Units
30766600 1 Units
30766600 1 Units
30766600 13 Units
30766600 1 Units
30766600 2 Units
30766600 1 Units
30766600 3 Units
30766600 1 Units
30766600 1 Units
orderid date units
30766600 090909 1
30766600 090909 1
30766600 090909 1
30766600 090709 1
30766600 090709 1
30766600 090609 13
30766600 090609 1
30766600 090509 2
30766600 090509 1
30766600 090509 3
30766600 090409 1
30766600 090409 1
30766600 090309
30766600 090409
30766600 090409
30766600 090309
30766600 090409