convert rows into column
hi
I have three tables holiday_mst, holiday_branches, and branch_mst
Branch_mst consist of following fields
branch_id branch_city
1 chennai
2 bangalore
3 calcutta
holiday_mst consist of following fields
holiday_id holidays
11 diwali
12 pongal
13 new year
holiday_branches consist of following fields
holiday_id branch_id status
11 1 1
11 2 1
11 3 1
12 1 1
12 2 0
12 3 0
now i want result in the following format
holidays chennai bangalore calcutta
diwali 1 1 1
Pongal 1 0 0
can anyone help me with this
Subject
Views
Written By
Posted
convert rows into column
3116
July 28, 2011 04:19AM
1070
July 30, 2011 12:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.