6 Replies Latest reply: Nov 20, 2012 4:09 PM by Sayan Malakshinov. RSS

    Select the last saved records in a table

    975290
      I all

      I have this struct in a table

      create table INT_OBJ
      (
      IDOBJ NUMBER(15) not null,
      IDERP NUMBER(15),
      IDE NUMBER(15),
      CPO VARCHAR2(20),
      VLR VARCHAR2(2500),
      VLRC VARCHAR2(2500)
      )

      How to Select the last saved records in a table. I think usea a temp table for put the last row read and begin to read in the next row.

      The table is reading each four hours.