描述: oracle查询某一时间节点的数据
select 所查字段,versions_starttime, versions_endtime, versions_operation
from 字段所在表 versions
between timestamp minvalue and maxvalue
where versions_starttime is not null
and [可以加一些条件筛选出来希望看的那条数据]
order by versions_starttime desc;
举例:
select column_name,versions_starttime, versions_endtime, versions_operation
from table_name versions
between timestamp minvalue and maxvalue
where versions_starttime is not null
and id = '唯一数据'
order by versions_starttime desc;