gistfile1.txt

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

insert into DEMO_TABLE (t_data) values ('test data 99');
update DEMO_TABLE 
   set t_data = 'test data X'
 where t_id <= 3;
commit;

select * from flashback_transaction_query
where 1=1
and logon_user = 'ADMIN'
and table_name = 'DEMO_TABLE';