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.

The code editor appears.

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

Using Find and Replace

Click Find & Replace to perform a basic search and replace.

Downloading a View

Click Download Source to save the current view as a file.