文章分类 - oracle
摘要:方法一:v$version SQL> select * from v$version; www.2cto.com BANNER Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production PL/SQL Re
阅读全文
摘要:1. 查询test表DML操作的最后时间的语句: select max(ora_rowscn),to_char(scn_to_timestamp(max(ora_rowscn)),'yyyy-mm-dd hh24:mi:ss') from test; 2. select TO_CHAR(LAST_D
阅读全文