While connected to the database, you might want to know the sql id of the query you just ran (in your own session, not some other session).
Let’s run a sample query
set serveroutput off Select * from hr.employees;
Now you might want to know the SQL ID of the above command. You must query PREV_SQL_ID column from V$SESSION
select prev_sql_id from v$session where sid=sys_context('userenv','sid');
You can check if the sql id returned above is correct by checking the SQL TEXT associated with the sql id
select sql_id, sql_text from v$sqltext where sql_id in ('fxdbrc4jhqn5r');