next up previous contents
Next: Query Processing Strategies Up: Update Queries Previous: Update Queries

Examples.

Consider class SEQUENCE of the OPM schema in Appendix A. The following update statement modifies a sequence:

         UPDATE S (
           SET generated_by = PROJECT [project_id = 20],
           SET length = 50,

Consider class CLONE of the OPM schema in Appendix A. The following UPDATE statement modifies all the clones generated by project 30:

          UPDATE C (
            SET clone_type = 'Unknown',
            SET owner = NULL 
          )
          FROM C in CLONE
          WHERE C.project.project_id = 30;

Note that carrying out an insert, delete, or update query entails enforcing the appropriate insert, delete, or update rules.

1


& Markowitz
Fri Jun 28 15:58:11 PDT 1996