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_7

7. Query the Database with Advanced SELECT Features

Jon Heller¹  

(1)

Clive, IA, USA

 

SELECT is the most important SQL statement type. Even when we’re changing data, most of the logic will go in the SELECT and WHERE clauses of the statement. Before we can insert, update, or delete a set, we must be able to choose a set.

This chapter introduces intermediate and advanced Oracle SQL SELECT features. Each topic could fill a whole chapter or maybe even a whole book. Instead of showing all the options and quizzing you on the syntax, this chapter focuses on breadth over depth and only tries ...