tranquilidad: Oracle Issues brings up an interesting scenario:
Yet for some reason, several times while all of us are logged on, one of us will try to run a query and will get the response "no rows selected" yet the other person can run the query and get results just fine. Just an observation...Have other groups had similar problems?
Generally, this is a result of things talked about in Chapter 5 of the SQL book. What happens is that one of you inputs your data during a session; the other runs a query on that data and gets no rows. It's because the person inputting the data has not done a COMMIT. Until you do a COMMIT, changes you make are only visible to you. The COMMIT makes changes to the database permanent and visible to people other than the person doing the change.