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';