I have this struct in a table
create table INT_OBJ
IDOBJ NUMBER(15) not null,
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.
What is the criteria to define the "last saved record"? That would normally involve some sort of DATE column in the table but I don't see any obvious candidates here. Can you use some other column such as the largest IDOBJ value instead?
Use IDOBJ is possible but IDOBJ change to varchar.
I have a PROCEDURE and this read the INT_OBJ and transpose field each four hours, my question is how to read the new registers or the last row inserted into INT_OBJ.
There is no concept of the "last row" of a heap organized table. You would need some column that you can create a predicate on that identifies the "last row".
If IDOBJ is a VARCHAR2, what is the "last" value? Do you want the row that has the IDOBJ value that is last alphabetically?