How to make a sql query from the past?

Question

SQL

How to make a sql query from the past state of a table?
1. Oracle SQL
2. Archive logs
Query for current state like:
select acct_num, balance/100 from iss_subacct_tab
where sub_type like '4V0101' and inst_id like '0001'

Answer 1

for oracle: select XX from YY versions between timestamp sysdate-1 and sysdate
https://docs.oracle.com/cd/B12037_01/appdev.101/b1...
stackoverflow.com/questions/359733/oracle-record-h ...

Answer 2

in MS SQL there is such a feature as CDC (Change Data Capture)
from which you can find the state of any field on a date (the retention period for changes is configurable)
I heard that Oracle also has this - but I don’t know how it is done in Oracle :)