By popular demand (one anonymous person — hey, it's all relative), another list.
OK, you may have played with them, found a hypothetical circumstance for them, but you've probably never found a real situation in which to use them, or if you have you've probably backed out at the last minute. Or the DBA won't let you use them. Or you found there was a bug that spoiled it.
More likely you will not even recognize them — unless you're one of those losers who enjoys browsing documentation of course. * ahem *
- The Subquery Factoring Clause: OK, a bit of a softball to start with. I bet that someone has used this. Not first time, but as part of a tuning exercise. And to show off.
- The Partitioning Clause of a Query Table Expression: Actually hardcoding a partition name in a query? Wellll, OK maybe.
- The Model Clause: This is great! What's it for?
- Multiset Operators: Or nested tables in general
- Submultiset: OK, that's cheating. Let's just say "nested tables"
- The CORR_K() Function: Oh wait, there was that time when … nah not really. Never used it.
- PowerMultiset_By_Cardinality: "…takes as input a nested table and a cardinality and returns a nested table of nested tables containing all nonempty subsets (called submultisets) of the nested table of the specified cardinality". * wipes-eyes * OK seriously, that's the last time I'm going to mention nested tables. Or nested tables of nested tables.
- Alter Sequence: Admit it … you thought you were going to be able to change the current value with it, but then found you just had to drop the sequence and recreate it, so that's what you did.
- Associate/Dissociate Statistics: What?
Well, I pride myself on the high education level of my readership, and also it's high regard for risk-taking. If you have actually used one of these features in a production system, and it has actually made it past the DBA/watchdog, then please reply under the heading "I have an unusual affinity for Shiny New Things, and have successfully used the following features in a production system:"