col task_name form a5 col segname form a30 col type form a15 col message form a80 select ao.type, ao.owner || '.' || ao.attr2 || decode (ao.attr3, '', '', '(' || ao.attr3 || ')') segname, af.message from dba_advisor_findings af, dba_advisor_objects ao where ao.task_id = af.task_id and ao.object_id = af.object_id and ao.owner = '&object_owner' order by 1, 2