Oracle查看表中的数据插入时间
SQL> select to_char(scn_to_timestamp(ORA_ROWSCN),'yyyy-mm-dd hh24:mi:ss:ff8') insert_time from c##a.emp t;
INSERT_TIME
--------------------------------------------------------
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
2020-03-30 22:13:57:00000000
INSERT_TIME
--------------------------------------------------------
2020-03-30 22:13:57:00000000
已选择 12 行。
参考https://bbs.csdn.net/topics/392606940?depth_1-utm_source=distribute.pc_relevant.none-task-discussion_topic-BlogCommendFromBaidu-1&utm_source=distribute.pc_relevant.none-task-discussion_topic-BlogCommendFromBaidu-1
update后,时间变为update时的时间,如果在建表时
create table test
(
id int,
name varchar(10)
)
rowdependencies;
增加了rowdependencies选项,或者加个时间戳字段 default sysdate,可以保持不变。(未测试,睡觉)