Oracle Database Search Results: SELECT

The SELECT INTO statement retrieves data from one or more database tables, and assigns the selected values to variables or collections.

You perform a Flashback Query using a SELECT statement with an AS OF clause.

This example shows how you can transfer varrays between PL/SQL variables and SQL tables.

Fortunately, it is straightforward in Oracle Database to prevent the anomaly described:

When you select a value from an Oracle database column into a PL/SQL character variable, whether the value is blank-padded or not depends on the variable type, not on the column type.

To do an out of place restore of the data, perform a CTAS (CREATE TABLE AS SELECT … AS OF …) using the Flashback Query SQL "AS OF …" clause.