Editing a View

When you edit a view you can edit the code manually, perform a search and replace, and compile the view. Additionally, you can save the view as a file or drop it.

Editing a View Manually

To edit a view manually:

On the Workspace home page, click SQL Workshop and then Object Browser.

Object Browser appears.
From the Object list, select Views.
From the Object Selection pane, select a view.
Select the Code tab.
Click Edit to activate manual edit mode.

If you edit and make changes to a view, you must compile. See "Compiling a View".

Note:

You can expand the Edit pane by clicking the Full Screen icon in the upper right of the pane, beneath the Create button.

Using Find and Replace

Click Find to perform a basic search and replace.

Downloading a View

Click Download to save the current view as a file.