7
SQL Statements

A whole is that which has a beginning, a middle, and an end.

Aristotle, Poetics

This chapter describes, in alphabetical order, Oracle SQL statements and major clauses. The description of each statement or clause contains the following sections:

Syntax	shows the keywords and parameters that make up the statement.
	Caution: Not all keywords and parameters are valid in all circumstances. Be sure to refer to the "Keywords and Parameters" section of each statement and clause to learn about any restrictions on the syntax.
Purpose	describes the basic uses of the statement.
Prerequisites	lists privileges you must have and steps that you must take before using the statement. In addition to the prerequisites listed, most statements also require that the database be opened by your instance, unless otherwise noted.
Keywords and Parameters	describes the purpose of each keyword and parameter. (The conventions for keywords and parameters used in this chapter are explained in the Preface of this reference.) Restrictions and usage notes also appear in this section.
Examples	shows how to use various clauses and parameters of the statement.

Press "Next" to go to the first SQL statement.