首页 > 技术文章 > Recovering deleted Records

BugQiang 2015-08-28 15:38 原文

[原文] recovering-deleted-records

Solution

That requires an actual timestamp (or date), you're passing a pair of values.

Try:

SELECT * FROM MY_TABLE
AS OF TIMESTAMP TO_DATE('13-MAR-11 08:50:58','DD-MON-YY HH24:MI:SS')

(Your time format specifier isn't correct either and doesn't match your date string.)

推荐阅读