Oracle: using "as of" clause with table aliases?

3 votes

2 answers

1625 views

                          I can run this flashback query with no problem:

    select x from a as of timestamp sysdate;

But if I use a table alias I get an error.

    select foo.x from a foo as of timestamp sysdate;
    ORA-00933: SQL command not properly ended

How can I use "as of" with table aliases?

Asked by Mark Harrison (829 rep)

Dec 8, 2015, 04:46 PM
Last activity: Sep 14, 2018, 01:34 PM

Oracle: using "as of" clause with table aliases?

Related Questions