Views Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Views Editor lets you work with view columns and manage the dependencies and permissions for the view.

To edit a view

  1. Open an editor on the view. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Displays a listing of the columns making up the view.

Definition

Lets you view and modify the DDL that will implement any changes made with the editor.

Comment

For details on using this tab, see Adding a Comment to an object.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.