background image
<< Creating a View in SQL Script | Dropping a View >>
<< Creating a View in SQL Script | Dropping a View >>

Updating a View

Using Views
Creating and Using Database Objects 3-23
Updating a View
To change the properties of a view in SQL Developer interface:
You will change the
salesforce
view by adding to it the employees in the Marketing
department, and then rename the view to
sales_marketing
.
1.
In the Connections navigation hierarchy, right-click the
salesforce
view.
2.
Select Edit.
3.
In the Edit View window, change the SQL Query by adding the following to the
last line: '
OR department_id = 20
'.
Click Test Syntax.
Click OK.
4.
To rename the view, right-click
salesforce
and select Rename.