This discussion is archived
6 Replies Latest reply: Nov 20, 2012 2:09 PM by xtender RSS

Select the last saved records in a table

975290 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points