RIYOSU

Select a.execution_end, b.type, b.impact, d.rank, d.type,
b.message,
c.command,
c.message,
d.benefit,d.benefit_type
from dba_advisor_tasks a, dba_advisor_findings b,
dba_advisor_actions c, dba_advisor_recommendations d
where a.owner=b.owner and a.task_id=b.task_id
and b.task_id=d.task_id and b.finding_id=d.finding_id
and a.task_id=c.task_id and d.rec_id=c.rec_Id
and a.status='COMPLETED'
and a.execution_end >= sysdate-1
order by d.rank asc, d.benefit desc