2.4.8 Exploring Kafka Data from a Specific Timestamp
In addition to reading records from a specific offset, Oracle SQL Access to
Kafka (OSaK) allows you to position an OSaK view to start at a particular timestamp and read
messages in a user defined window of time. As compared to
ORA_KAFKA.SEEK_OFFSET
which is restricted to OSaK views that map to
only one Kafka topic/partition, ORA_KAFKA.SEEK_OFFSET_TS
can be used on any
OSaK view. The ORA_KAFKA.SEEK_OFFSET_TS
procedure is used to specify a
window of time for an OSaK view.