Chapter 5

Query Development, Privileges, and Derived Structures

In this chapter we show you how to approach and develop a query. One way to create long queries is to begin modestly, and to build up to the query of interest. In this process of “building up” the query, parentheses often need to be appropriately placed. We will illustrate this stepwise approach by developing a few queries in this chapter, and we will discuss how parentheses can aid in query development.

Another way to develop queries is to use derived structures. Derived structures include temporary tables, views (both real and inline views), and snapshots (also known as materialized views). Each of these derived structures allows us to easily manipulate partial displays of the ...

Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.