View Editor
Use the View Editor to view, create, or alter views.
|
About Views |
A view is a query that is named in the database so that it can be used as if it were a table. It can be thought of as a virtual table in the database whose contents are defined by the Select query. You can use views to rearrange, filter and select the way you see data in tables without creating any copies of that data. Views help make data access simpler by hiding complexities. They can also help separate data for different users as a security measure. SQL Navigator’s view editor makes it easy to create and alter views. Although you won’t need to type any PL/SQL code when editing views in SQL Navigator, you should be familiar with Oracle rules and guidelines for using views. The attributes of this database object are described in Oracle documentation. |
Using The Editor
Editor Toolbar
| Icon | Tool Tip | Description |
|---|---|---|
 |
Create new view | Click to open the New View dialog. |
 |
Open object from DB | Open an existing view. |
 |
Clone current view | Create a clone of the selected view. You will be prompted in the New View dialog to enter a new name. |
 |
Revert to pervious view | Undo or revert any modifications made to the view. |
 |
Generate SQL for changes | Generate SQL code for the changes made. |
 |
Apply changes to DB | Apply changes to the database. |
Editor Tabs
| Tab | Description | ||||||
|---|---|---|---|---|---|---|---|
|
Text |
| ||||||
|
Columns |
| ||||||
|
Options |
Select from the available options to be applied to the view. | ||||||
|
Comment |
Enter any comments related to the view. |
Ways to Open The View Editor
| Icon | Action | Description |
|---|---|---|
| |
From the Main Menu View Menu | Visual Object Editors | View Editor |
Open the View Editor. |
 |
From DB Navigator or Find objects Dialog Right click on a View object and click Open. |
Open the selected object in the View Editor. |