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.
Important Notes
- 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 details, see Views (Oracle) - Properties.
- Definition panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button 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 will display the data you’re interested in seeing. The template is CREATE VIEW <name> AS
SELECT: Identify the columns you want to show in the view
FROM: Identify the table(s) you want to draw the data from
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.