Examples

Example 1: Insert a comment for the EMPLOYEE table.

   COMMENT ON TABLE EMPLOYEE
     IS 'Reflects first quarter 2000 reorganization'

Example 2: Insert a comment for the EMP_VIEW1 view.

   COMMENT ON TABLE EMP_VIEW1
     IS 'View of the EMPLOYEE table without salary information'

Example 3: Insert a comment for the EDLEVEL column of the EMPLOYEE table.

   COMMENT ON COLUMN EMPLOYEE.EDLEVEL
     IS 'Highest grade level passed in school'

Example 4: Enter comments on two columns in the DEPARTMENT table.

   COMMENT ON DEPARTMENT
     (MGRNO IS 'EMPLOYEE NUMBER OF DEPARTMENT MANAGER',
      ADMRDEPT IS 'DEPARTMENT NUMBER OF ADMINISTERING DEPARTMENT')

Example 5: Insert a comment for the PAYROLL package.

   COMMENT ON PACKAGE PAYROLL
     IS 'This package is used for distributed payroll processing.'