--查询回收站中已经被删除的表
/* select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
--恢复回收站中被删除的表
flashback table TB_WD_ORG_CFGUNITJOBHEADCOUNT to before drop;*/
--闪回数据 删除数据之前的时间点
/*select *
from tb_inf_employee AS OF TIMESTAMP TO_TIMESTAMP('2015-06-01 15:00:00', 'yyyy-mm-dd hh24:mi:ss')
where c_code = '123456';*/
---执行含有特殊符号的orcal语句
set feedback off
set define off
要执行的sql语句
prompt Done.