© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
J. HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-8867-2_19

19. Solve Challenging Problems with Arcane SQL Features

Jon Heller1  
(1)
Clive, IA, USA
 

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

Get Pro Oracle SQL Development: Best Practices for Writing Advanced Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.