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

Question

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?

score 4 · Accepted Answer · edited Dec 08 '15 at 22:26

4

The table alias follows the "as of" clause.

select x from a as of timestamp sysdate foo;

edited Dec 08 '15 at 22:26

Mark Harrison

answered Dec 08 '15 at 20:24

Raj

score 1 · Answer 2 · answered Sep 14 '18 at 13:34

And as an extension if you are joining multiple tables you can join them from different times if you want (not sure why you would want but...)

select *
from a as of timestamp sysdate-1 foo
join b as of timestamp sysdate-2 fi on foo.name = fi.name;

2 Answers2