When you write your sql statement then do a Pivot & Chart using Toad Data Point, how do you see the code that made the pivot?
Our pivot grid does not use SQL to pivot. We use the existing result set and aggregate the rows in a third party component.
Hi Debbie,
Can we do pivot table in the display and query builder?
If yes, do you know the syntax or can you share a sample query?
Thank you!!!
BR/// Anthony Arada
To pivot the data from a result set you just click the pivot tab or send to pivot window. As mentioned we do not use SQL to aggregate for pivots. This is done in lC# code.
Otherwise there are sql examples on the internet.
http://www.databasejournal.com/features/oracle/how-to-pivot-data-in-oracle-11g.html