Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© Jon Heller 2019

Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_19

19. Solve Challenging Problems with Arcane SQL Features

Jon Heller¹ 

(1)

Clive, IA, USA

 

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 ...