The next step in creating your database is to build VIEWS. Views are essentially queries that show, in table format, the information you have selected.
So select NEW VIEW from the drop down menu. Give it a name and owner and then select the DESIGN tab.
Select the database, you should only have one choice. Open the folders that contain your tables.
Inside these tables you should see all of the attributes.



At the bottom of this window is the section where you define what you want the view to display.
To begin double click on the first attribute you want in your SELECT statement.
Then go to the conditions section and type in the portion of your WHERE statement that applies to that attribute.

Repeat for each item to be in the view.



In this example I have selected PET_NAME and OWNER_NAME using the mouse.

In the CONDITION column for the PET_NAME I have typed :
HOPEMAN.PETS.PET_OWNER = HOPEMAN.OWNERS.OWNER_NAME

In the CONDITION column for OWNER_NAME I have typed:
HOPEMAN.OWNERS.CITY = 'Pittsburgh'

This gives the view the following Select-From-Where statement:

Select : PET_NAME, OWNER_NAME
From : HOPEMAN.PETS, HOPEMAN.OWNERS
WHERE : HOPEMAN.PETS.PET_OWNER = HOPEMAN.OWNERS.OWNER_NAME AND HOPEMAN.OWNERS.CITY = 'Pittsburgh'

Which produces the following view:



Once you have created all of your tables and views you will need to dismount your active database,
unless it was not mounted when you started Oracle8 Navigator,
for the tables and views to be added to the active database folders.
Then remount the database and select the view or table folders and see that your new objects have been added.


Return to General Directions
Return to Cs 1555