FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database.

 

FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database.

The database must have at least minimal supplemental logging enabled to avoid unpredictable behavior.

select 

xid,

start_scn,

start_timestamp,

commit_scn,

commit_timestamp,

logon_user,

undo_change#,

operation,

table_name,

table_owner,

row_id,

undo_sql

from 

flashback_transaction_query;

if you want to know column_name,data_type  for a table,view, etc then execute below query:-

select column_name,data_type from all_tab_columns where table_name='&table';