Oracle Generate AWR SQL Report Through SQL

oracle_awrsqrpt_sql.sql

-- Find the dbid, instance_number and begin and end snap_id to be used.

select
    snap_id,
    dbid,
    instance_number,
    begin_interval_time,
    end_interval_time
from
    dba_hist_snapshot
order by
    snap_id desc;


-- Plugin dbid, instance_number, begin stap_id, end_snap_id and SQL_ID.

select
    output
from
    table(
        dbms_workload_repository.awr_sql_report_text(
            l_dbid     => dbid,
            l_inst_num => instance_number,
            l_bid      => begin_interval_time,
            l_eid      => end_interval_time,
            l_sqlid    => 'SQL_ID'
        )
    );