Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

Transpose using SQL PIVOT

Views

Comments

User_WHB5J Rank 1 - Community Starter

September 2016 in Oracle Transactional Business Intelligence

Content

I know you can transpose using SQL pivot. But to use PIVOT you need to use an aggregate. In some situations you dont want to use an aggregate. eg: what if you want to show the value in separate rows? How do you transpose in such situation?

Oracle Transactional Business Intelligence

Welcome!

Quick Links

Categories

Transpose using SQL PIVOT

Content

Welcome!