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 to show you what is possible. The first step to advanced programming ...
