Outlines Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Outlines Editor lets you view information on an outline, and modify its category and associated SQL statement.

Note: The only SQL statements possible with stored outlines are SELECT, DELETE, UPDATE, INSERT…SELECT, and CREATE TABLE…AS SELECT.

To edit an outline

  1. Open an editor on the outline. 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

In addition to displaying basic creation and identification properties, this tab lets you select a new Category for the outline.

Definition

Lets you view and modify the SQL Statement associated with the outline.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

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