Newbie Q - Help on Tbl Logic

Ex.

    Have transaction table T.

        T (inserted DATE
           ,info        NUMBER)

    User 1 Queries on table t periodically.     SELECT * FROM t WHERE fld1 >= oldRange;

• process *** oldRange := fld1; -- of last record read.

    But during this query User 2 inserts new row where fld1 falls in the range just read.

    So the next query by User1 will miss this new record.

Question.

    Does oracle basically have a sequence or date to be queried off of to grabbed everything

    that is new to a particular table for the above senario.

Thanks in advance for any articles or suggestions. Received on Wed May 03 2000 - 00:00:00 CDT