Oracle SQL - Pivot on Date

Asked Oct 28 '21 at 15:10

Active Oct 28 '21 at 15:10

Viewed 26 times

I have the following data:

**TYP                                       CNT     VALUE     ORDER_DATE**
Collect from Store - Payment Confirmed      1397    3000      28-OCT-2021
Collect from Store - Payment Confirmed       277    1500      27-OCT-2021

I want to show result as:

**TYP                                      VALUE     27-OCT-2021  28-OCT-2021**
Collect from Store - Payment Confirmed      4500         277        1397

How to apply the pivot?

asked Oct 28 '21 at 15:10

Imran Hemani

Are there only 2 rows or they can be dynamic upto 100s of rows? – Ankit Bajpai Oct 28 '21 at 15:15
dynamic.. can be multiple – Imran Hemani Oct 28 '21 at 15:16
Then you would need a dynamic pivot, which is more work, but there are lots of examples. However, this seems like something an application or reporting layer should handle, perhaps. – Alex Poole Oct 28 '21 at 15:20
You can check out [`these questions`](https://stackoverflow.com/questions/tagged/dynamic-pivot%2boracle?tab=Frequent) for dynamic cases – Barbaros Özhan Oct 30 '21 at 21:48

Oracle SQL - Pivot on Date

0 Answers0