79967

Test the new KING_VIEW view:

1.    In the Connections navigator, navigate to the Views node in the HR schema and find the KING_VIEW, by following the instructions in "Displaying Views" on page 8-25.

Managing Program Codę Stored in the Database Managing Schema Objects 8-27

2.    Click the KING_VIEW.

A tab with the vicw name appcars in the objcct pane. with the Columns subtab displaycd.

3.    Click the Data subtab in the object pane.

The data selected by the view appears.

4.    (Optional) You can also test the view by submitting the following SQL statement in SQL*Plus or SQL Developer:

SELECT + FROM hr.king_view