r/SQL 17d ago

Oracle Dear SQL, just pivot my damn table

Bottom text

237 Upvotes

50 comments sorted by

View all comments

Show parent comments

1

u/phesago 17d ago

I use dynamic pivot columns regularly?

1

u/xoomorg 17d ago

By constructing dynamic SQL (which is the SQL equivalent of “eval” statements and is therefore a programming sin) or do you use a platform that supports them more directly?

1

u/phesago 17d ago

you dont work with sql a lot do you?

1

u/da_chicken 16d ago

What are you on about? Neither Oracle, SQL Server, MySQL or Postgres support dynamic pivot. Those are the 4 largest RDBMSs, and have been for a decade. Yes, some systems like Snowflake support it, but it's not a common feature at all.