Creating Views

To create views, use either the SQL Developer tool Create View or the DDL statement CREATE VIEW. This topic shows how to use both of these ways to create these views:

• SALESFORCE, which contains the names and salaries of the employees in the Sales department

• EMP_LOCATIONS, which contains the names and locations of all employees

These view are part of the sample application that the tutorials and examples in this document show how to develop and deploy.

This section contains:

• Tutorial: Creating a View with the Create View Tool

• Creating Views with the CREATE VIEW Statement