Example 1

    Assume you wish to erase all the records in the COLLEGES
    relation:

    RDO> START_TRANSACTION READ_WRITE RESERVING
    cont>  COLLEGES FOR EXCLUSIVE WRITE
    RDO> FOR C IN COLLEGES ERASE C END-FOR
    RDO> PRINT COUNT OF C IN COLLEGES
     0
    RDO> COMMIT

    This statement uses the loop established by the FOR statement and
    erases all the records from the COLLEGES relation.