Select

Retrieve data from the database.

Subquery

Subquery factoring

Select list

Table reference

Flashback

Query table expression

Sample

Subquery restriction

Table collection expression

Joined table

Join type

Hierarchical query

Group by

Rollup cube

Grouping sets

Grouping expression list

Expression list

Order by

For update