select t.*,
t.rowid,
to_char(scn_to_timestamp(ORA_ROWSCN), 'yyyy-mm-dd hh24:mi:ss') insert_time
from t2 t;
select t.*,
t.rowid,
to_char(scn_to_timestamp(ORA_ROWSCN), 'yyyy-mm-dd hh24:mi:ss') insert_time
from t2 t;
转载于:https://www.cnblogs.com/cczz_11/archive/2012/03/20/2408990.html