select cp.capture_name, cp.parameter, cp.value, cp.set_by_user,
cp.source_database
from dba_capture_parameters cp, all_capture ac
where cp.capture_name = ac.capture_name
View Text - HTML Formatted
SELECT CP.CAPTURE_NAME , CP.PARAMETER , CP.VALUE , CP.SET_BY_USER ,
CP.SOURCE_DATABASE
FROM DBA_CAPTURE_PARAMETERS CP , ALL_CAPTURE AC
WHERE CP.CAPTURE_NAME = AC.CAPTURE_NAME