Tips for Using Flashback Query

Keep the following in mind when using a Flashback Query (SELECT ... AS OF):

You can specify or omit the AS OF clause for each table in the query and specify different times for different tables. Use an AS OF clause in a query to perform data definition language (DDL) operations (such as creating and truncating tables) or DML operations (such as inserting and deleting) in the same session as the query.
To use the results of a Flashback Query in a DDL or DML statement that affects the current state of the database, use an AS OF clause inside an INSERT or CREATE TABLE AS SELECT statement.