Creating Views

The user name you use to create a connection must have adequate privilege to create a view, either by having been granted CREATE VIEW privilege or having been granted a role such as administrator that contains the privilege. If you did not create the connection with a user with the correct privileges, you will not be able to select View from the New Gallery.

To create a view:

Select View | Connection Navigator .
Expand Database and select a database connection.
In the connection, expand a schema.
In the schema, right-click the Views folder and choose New View.
The Create View dialog opens. Enter parameters and select options to define the view.
Click OK to create the view.

For information about how to supply values for the parameters and options in this dialog, click Help, or see the CREATE VIEW section of the Oracle Database SQL Reference, available from the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.

Context Menu Shortcut:

From the Connection Navigator, select the Views folder in a schema and right-click it, then select New View.