SELECT TEXT FROM DBA_SOURCE AS OF TIMESTAMP TO_TIMESTAMP('2012-05-21 15:00:00', 'YYYY-MM-DD HH24:MI:SS') WHERE OWNER = 'DW' AND TYPE = 'PROCEDURE' AND NAME = 'P_DW_V_USER_CHARGE_EXT_DAILY' ORDER BY LINE;
但是 使用该语句的权限还不太清楚。是否必须使用sys 用户操作才行,还望刘大赐教,希望刘大能总结一下oracle flash back 语句的一些使用技巧