... under Repeatable Read the second select will reflect intervening committed Inserts, Updates and Deletes; under Read Committed no intervening Updates or Deletes will have been allowed; under Serializable no Updates Deletes or Inserts will have been allowed.

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.