0👍
✅
Assuming that the source database table contains an ID
column that is incremented by a SEQUENCE
, you can repeatedly select new data as follows:
SELECT * from <table name> where ID > :lastSelectedID
ORDER BY ID ASC;
In case the source table contains a column that holds the insertion date/time (i.e. CREATED
), the same could look as follows:
SELECT * from <table name> where CREATED > :lastSelectedCreated
ORDER BY CREATED ASC;;
Source:stackexchange.com