SQL> select COUNT(*) from dba_objects where created< to_date('17-01-14','dd-mm-y
y') AND owner='用户名' and object_type='TABLE';
==============================================================
查询某个时间之后创建的表有哪些：
SQL> select object_name,created from dba_objects where created> to_date('17-01-1
4','dd-mm-yy') AND owner='用户名';
================================================
查询当前用户下某个表的创建时间：
SQL> select object_name,created from dba_objects where object_name ='DN_EMPLOYEE
' AND owner='用户名';
==============================================
连接oracle并执行文件，并将执行结果保存到log文件中：
C:\Users\admin>sqlplus用户名/密码@ORCL @D:\aaa.sql > d:\sqlout.log;
==============================================
执行bat文件完成上面的任务：
@echo off
sqlplus %connection% @D:\data_carryover\select_table.sql > D:\data_carryover\select_table_log.log
@echo Create End!
pause
将以上代码保存到bat类型的文件中，并执行
================================
注意：用oracle数据库创建的用户名替换上面内容中的‘用户名’三个字，密码同理。
