select a.id as id,
d.name as advisor_name,
dbms_advisor.format_message(a.finding_name) as finding_name
from (select rownum-1 as id, advisor_id, finding_name
from x$keafdgn) a,
WRI$_ADV_DEFINITIONS d
where a.advisor_id = d.id
SELECT A.ID AS ID
,
D.NAME AS ADVISOR_NAME
,
DBMS_ADVISOR.FORMAT_MESSAGE(A.FINDING_NAME) AS FINDING_NAME
FROM (SELECT ROWNUM-1 AS ID
, ADVISOR_ID
, FINDING_NAME
FROM X$KEAFDGN) A
,
WRI$_ADV_DEFINITIONS D
WHERE A.ADVISOR_ID = D.ID
|
|
|