I’m Chris Saxon, an Oracle Developer Advocate for SQL. My job is to help you get the best out of the Oracle Database and have fun with SQL!
List partitions are great when you have a column with a specific set of values you want to carve into separate partitions. Things like states, countries…
It’s a question that frequently comes up on Ask TOM: