SQL Database Implementation for the Commonweather Corporation › Logical Database Definition Listing for the Commonweather Database › View Definitions

View Definitions

SQL-defined views allow an application program to see just a portion of the database. A view can be used to introduce security.

Below are some sample views that might be created for the Commonweather database:

   CREATE VIEW EMPSCHM.SS_FORMAT
          (EMP_ID, EMP_LAST_NAME, EMP_FIRST_NAME, SS1, SS2, SS3)
          AS SELECT EMP_ID, EMP_LAST_NAME, EMP_FIRST_NAME,
                    SUBSTR(SS_NUMBER, 1, 3), SUBSTR(SS_NUMBER, 4, 2),
                    SUBSTR(SS_NUMBER. 6, 4)
             FROM EMPSCHM.EMPLOYEE;
 
   CREATE VIEW EMPSCHM.EMP_HOME_INFO
          AS SELECT EMP_ID, EMP_LAST_NAME, EMP_FIRST_NAME, STREET,
                    CITY, STATE, ZIP_CODE, PHONE
             FROM EMPSCHM.EMPLOYEE;
 
   CREATE VIEW EMPSCHM.EMP_WORK_INFO
          AS SELECT EMP_ID, START_DATE, TERMINATION_DATE
             FROM EMPSCHM.EMPLOYEE;