Correlation names are most often used in a correlated query.

Other references to the table, view, or materialized view throughout the query must refer to this alias.

clause to identify a subquery block, table, view, materialized view, partition, or subpartition, or to specify a subquery that identifies the objects.

For the purposes of name resolution, these function names have precedence over schema-level stored functions.

If the query in which you specify this clause is not a top-level is subject to the same naming conventions and restrictions as database schema objects.

Oracle Database returns all committed versions of the rows that existed between two SCNs or between two timestamp values.

The first specified SCN or timestamp must be earlier than the second specified SCN or timestamp.

When used in the subquery of a DML statement, you can specify this clause in a subquery in the can be a subquery, a column, a function, or a collection constructor.

Regardless of its form, it must return a collection value—that is, a value whose type is nested table or varray.

lets you write cross-tabulation queries that rotate rows into columns, aggregating data in the process of the rotation.

The output of a pivot operation typically includes more columns and fewer rows than the starting data set.

The rows returned include deleted and subsequently reinserted versions of the rows. Oracle Database returns rows as they existed at the specified system change number or time.