It’s time to discuss the most advanced Oracle features. These features can solve extremely challenging problems; the kind of problems that many developers think are impossible to solve in a database.
We need to be cautious before using these features. Just because we can use a feature doesn’t mean we should use it. Half of the features in this chapter I’ve only used for code golf, to solve a ridiculous challenge. The other half I’ve used in real-world systems, where a rare SQL feature really saved the day.
First we need to honestly evaluate the cost and benefits of ...
