view

Description

Identifies a view that contains the base table to be scanned.

Syntax

view view_name

Parameters

view_name

is the name of a view specified in the query. If the query uses the database name and/or owner name, the abstract plan must also provide them.

Examples

Example 1

create view v1 as 
select * from t1

select * from v1

( t_scan ( table t1 ( in ( view v ) ) ) )

Identifies the view in which table t1 is used.

Usage

See also

in, table