gistfile1.txt

CREATE TABLE DEMO_TABLE (
  T_ID    NUMBER GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 START WITH 1, 
  T_DATA  VARCHAR2(200 BYTE)
);

insert into DEMO_TABLE (t_data) values ('test data 1');
insert into DEMO_TABLE (t_data) values ('test data 2');
insert into DEMO_TABLE (t_data) values ('test data 3');
commit;

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