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