サポートと今すぐチャット
サポートとのチャット

SQL Navigator for Oracle 7.4 - Release Notes

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

Field Description

Create View (

Enter the view column names, separated by commas.

) AS

Type the SQL for the view.

If you enter the Select * syntax to include all the table columns in the view, then all the table column names from the Select * table appear automatically in the CREATE VIEW pane.

Columns

  1. Select a column.
  2. Right click and select Edit Comments
  3. Enter any comments required.
  4. Repeat for each column as appropriate.

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.

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択