web analytics

WITH Clause In Oracle PLSQL

Options
@2020-05-15 22:36:05

The WITH clause lets you assign a name to a subquery block. You can then reference the subquery block multiple places in the query by specifying the query name. Oracle optimizes the query by treating the query name as either an inline view or as a temporary table.

A WITH clause is really best used when the result of the WITH query is required more than one time in the body of the query.

Comments

You must Sign In to comment on this topic.


© 2022 Digcode.com