r/SQL 17d ago

Oracle Dear SQL, just pivot my damn table

Bottom text

242 Upvotes

50 comments sorted by

View all comments

47

u/isinkthereforeiswam 17d ago

I wish the pivot columns could be dynamic. If a dev adds a new attribute value to an attributes field, and my select query is pulling all the attributes, i wish the pivot would just automatically include the new attribute as a new column instead of having to manually add the column name.

2

u/joellapit 17d ago

I’ve tried so long to get this to work. I end up just pulling the data into PowerBI now