Views Wizard (Oracle)
Go Up to Oracle Object Wizards
Views are SQL queries stored in the system catalog that customize the display of data contained in one or more tables. Views behave like tables because you can query views and perform data manipulation operations on them. However, views do not actually store any data. Instead, they depend on data contained in their base tables. You can use views to help enforce corporate security policies by creating a view that limits information a user can see.
Note: To create a view in your own schema, you need CREATE VIEW privileges. To create a view in someone else's schema, you need CREATE ANY VIEW privileges.
To create a new view using a wizard
- Open a creation wizard for a view. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel. For more information about the Properties panel, see the following topic.
- Definition panel. For more information about the Definition panel, see Previewing the DDL Generated to Create the New Object.
- Click Execute to create the object.
Views (Oracle) - Properties
When creating or editing a view, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Owner |
Select the owner of the view. The owner of the view must have SELECT privileges for the tables in the CREATE view statement or DBADM authority on the database that contains the table. |
|
Name |
Provide a name for the view. |
Views (Oracle) - Definition
This is where you build the query that displays the data you want to view. The template is:
CREATE VIEW <name> AS
SELECT: Identify the columns you want to show in the view.
FROM: Identify the table(s) from which you want to draw the data.
WHERE: Write the equivalence you want to view.
You can use the Query Builder to help you write the appropriate SQL statement. For details, see Query Builder.