Question

oracle数据库插入数据的时间 有自动记录么？ 如果有的话怎么取啊？

Answer 1

可以加个字段　获取插入时间

追问

不加字段有方法么？

追答

记得oracle　11g中有个新特性FLASHBACK_TRANSACTION_QUERY。可以实现你这功能，具体如何用给你可以搜索下

追问

10g 的有么 ？ 大侠。

Answer 2

供参考
10 g有FLASHBACK_TRANSACTION_QUERY

http://blog.csdn.net/lrunyang/article/details/6770281

Answer 3

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

SQL> select * from flashback_transaction_query;

XID START_SCN START_TIMESTAMP COMMIT_SCN COMMIT_TIMESTAMP LOGON_USER UNDO_CHANGE# OPERATION TABLE_NAME TABLE_OWNER ROW_ID UNDO_SQL
---------------- ---------- --------------- ---------- ---------------- ------------------------------ ------------ -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ------------------- --------------------------------------------------------------------------------
01002B0062680100 4062408454 2012-5-16 11:58 4062408458 2012-5-16 11:58: