viewName

A viewName represents a table or a view. To create a view, use the CREATE VIEW statement.

Syntax

[ schemaName. ] SQLIdentifier

You can qualify a view name with a schemaName. If a qualified view name is specified, the schema name cannot begin with SYS.

Example

-- This is a view qualified by a schemaName
SELECT COUNT(*) FROM SAMP.EMP_RESUME