Tutorial: Creating a View with the Create View Tool

This tutorial shows how to create the SALESFORCE view using the Create View tool.

To create the SALESFORCE view using the Create View tool:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Right-click Views.

   A list of choices appears.

3. Click New View.

   The Create View window opens, with default values for a new view.

4. For Schema, accept the default value, HR.

5. For Name, enter SALESFORCE.

6. Click the tab SQL Query.

   The SQL Query pane appears.

7. In the SQL Query field:

   • After SELECT, type:

     FIRST_NAME || ' ' || LAST_NAME "Name", SALARY*12 "Annual Salary"
     

   • After FROM, type:

     EMPLOYEES WHERE DEPARTMENT_ID = 80
     

8. Click Test Syntax.

   A message appears in the field SQL Parse Results.

9. If the message is not "No errors found in SQL", return to step 7 and correct the syntax errors in the query.

10. Click OK.

    The view SALESFORCE is created. To see it, expand Views in the navigation frame.