Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. HellerPro Oracle SQL Developmenthttps://doi.org/10.1007/978-1-4842-8867-2_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, 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 ...