Create automatic sql tuning task advisor report for special sql_id

--  Yannick Jaquier blog helps me to create this solution. Thank you Sir!
--  https://blog.yannickjaquier.com/oracle/automatic-sql-tuning-task-overview.html
spool c:\dropit\sqlidautosqltune.txt
exec dbms_output.put_line('#####find which execution_name and object_id has this sql_id run')
select distinct execution_name,object_id,trunc(TIMESTAMP) from DBA_ADVISOR_SQLPLANS where sql_id='&sqlid';
-- DBA_ADVISOR_SQLSTATS also have execution_name and object_id as in DBA_ADVISOR_SQLPLANS, but not always, I randomly checked about ten sql_id, all of them exists in DBA_ADVISOR_SQLPLANS, but some of them are not in DBA_ADVISOR_SQLSTATS
exec dbms_output.put_line('#####gather the execution_name and object_id which has the sqlid, run report on it')
SET lines 200 pages 1000
SET LONG 999999999
SET longchunksize 200
SELECT DBMS_AUTO_SQLTUNE.REPORT_AUTO_TUNING_TASK('&&execution_name','&&execution_name','TEXT','ALL','ALL',&&object_id) FROM dual ; 
undefine execution_name
undefine object_id
spool off

Now I can get the report quickly and review the report file.