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 Code Stored in the Database
Managing Schema Objects 8-27
2. Click the KING_VIEW.
A tab with the view name appears in the object pane, with the Columns subtab
displayed.
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
... zobacz całą notatkę
Komentarze użytkowników (0)