--查询最近十分钟用户ID为198的行所有改动记录
select versions_xid,
employee_id,
first_name,
last_name,
email,
phone_number,
hire_date,
job_id,
salary,
commission_pct,
manager_id,
department_id
from EMPLOYEES versions between timestamp sysdate - 1 / 24 / 6 and sysdate
where employee_id = 198;
select versions_xid,
employee_id,
first_name,
last_name,
email,
phone_number,
hire_date,
job_id,
salary,
commission_pct,
manager_id,
department_id
from EMPLOYEES versions between timestamp sysdate - 1 / 24 / 6 and sysdate
where employee_id = 198;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16670387/viewspace-683899/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
