Recovering deleted Records

[原文] 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.)

转载于:https://www.cnblogs.com/BugQiang/p/4766679.html