Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE EMP(EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2),COMM NUMBER(7,2),DEPTNO NUMBER(2));
select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.31.51.678270 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

5c0tty145sddp

update EMP set ENAME='LARRY ELLISON' where JOB='PRESIDENT' /* 01-APR-21 06.32.11.963644 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

0rac13hrmtrqm

select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.33.82.691464 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

0c12g0mwq09va

update EMP set ENAME='LARRY PAGE' where JOB='PRESIDENT' /* 01-APR-21 06.35.66.5728590 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

g00g13fys2fqd

select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.41.26.238008094 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

gcp12yf4n2r3c

update EMP set ENAME='BILL GATES' where JOB='PRESIDENT' /* 01-APR-21 06.30.35.4055430 AM +02:00 */;
select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.31.18.2381810 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

azur3g4pr7mng

update EMP set ENAME='JEFF BEZOS' where JOB='PRESIDENT' /* 01-APR-21 06.45.35.4055430 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

4m4z0n7sadpm2

select * from EMP where JOB='PRESIDENT' /* 01-APR-21 06.51.00.0102180 AM +02:00 */;
select prev_sql_id from v$session where sid=sys_context('userenv','sid');

PREV_SQL_ID

awss8rgcfkprm