It’s time to discuss the most advanced Oracle features, the features that solve problems most developers think are impossible to solve in a database.
We need to be cautious before using these obscure technologies. Just because we can use a feature does not 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 saved the day. Before we briefly describe Oracle’s ...