Outlines Editor (Oracle)
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
- Open an editor on the outline. For details, see Opening an Object Editor.
- 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.